10+ Factals Infotech Solutions Interview Questions and Answers

The technical challenges during project implementation

• Integration with legacy systems

• Ensuring data security and privacy

• Optimizing performance and scalability

• Dealing with compatibility issues across different platforms

• Implementing complex business logic

• Managing dependencies and version control

Expression to sum sales for India in 2009 without filters

• Use the SUM function to calculate the total sales

• Use the IF function to filter for India and 2009

• Wrap the IF function inside the SUM function

• Example: SUM(IF(Country='India' AND Year=2009, Sales, 0))

To get the sum of a range of data, use the SUM function in Excel or write a loop in programming languages.

• In Excel, select the range of data and use the SUM function.

• In programming languages, write a loop to iterate through the range and add up the values.

• Make sure to properly define the range of data to avoid errors.

• Consider using built-in functions or libraries to simplify the process.

To get dimension field values in KPI for dim having highest sales, use MAX function with GROUP BY clause.

• Use MAX function to get the highest sales value for the dimension field

• Use GROUP BY clause to group the data by the dimension field

• Select the dimension field along with the MAX function in the SELECT statement

• Example: SELECT dim_field, MAX(sales) FROM table_name GROUP BY dim_field

Interrecord functions are used to manipulate data between records in a database.

• Interrecord functions allow for calculations and data manipulation between related records in a database

• Examples include summing values from related records or calculating averages

• Limitations may include performance issues with large datasets or complex calculations

To make KPI objects static to selections, use set analysis in QlikView or Qlik Sense.

• Use set analysis to define a fixed set of data for the KPI object

• Use the dollar sign expansion to create a dynamic set of data based on selections

• Use the 'Only' function to limit the KPI object to a single value

• Use the 'Total' function to display the KPI object regardless of selections

It depends on the specific use case and data structure.

• Apply map is useful for applying a function to each element of a column or series.

• Join is useful for combining data from multiple tables based on a common column.

• Concatenation is useful for combining data from multiple columns or series into a single column or series.

• Consider the size and complexity of the data, as well as the desired output format, when choosing between these methods.

Issues faced while development

• Bugs and errors in code

• Integration issues with other systems

• Lack of proper documentation

• Scope creep and changing requirements

• Difficulty in testing and debugging

• Performance issues

• Security vulnerabilities

• Lack of communication and collaboration within team

Performance optimization techniques involve identifying and resolving bottlenecks in software applications.

• Use profiling tools to identify performance bottlenecks

• Optimize database queries and reduce network latency

• Minimize resource usage by optimizing algorithms and data structures

• Use caching to reduce the number of requests to external resources

• Implement lazy loading to defer loading of non-critical resources

• Use compression to reduce the size of data transferred over the net...read more

Developed a mobile app for a retail company to improve customer experience

• Implemented a user-friendly interface with easy navigation

• Integrated a loyalty program to incentivize customers

• Challenges included optimizing app performance and ensuring compatibility with various devices

• Received positive feedback from both the client and end-users