Qlikview Developer Interview Questions and Answers

3 tier architecture is a client-server architecture consisting of presentation, application, and database layers.

• Presentation layer: User interface for interaction with the application

• Application layer: Business logic and processing of user requests

• Database layer: Storage and retrieval of data

• Each layer communicates with the layer above and below it

• Allows for scalability and separation of concerns

Mapping load is a way to map data from one table to another in Qlikview.

• It is used to create a new table by mapping data from an existing table.

• It is useful when the data in the source table needs to be transformed or manipulated before being loaded into the new table.

• It can be used to join tables based on common fields.

• Syntax: Map using from ;

Incremental refresh is a process of updating only the new or changed data in a dataset, rather than refreshing the entire dataset.

• Incremental refresh helps in reducing the time and resources required for data refresh.

• It is commonly used in data warehousing and business intelligence to keep the data up-to-date.

• For example, in a sales database, only the new sales transactions since the last refresh would be added to the dataset during an incremental refresh.

Joins in QlikView are used to combine data from multiple tables based on a common field.

• Joins are used to link tables together based on a common field or key.

• Common types of joins in QlikView include inner join, left join, right join, and outer join.

• Joins help in creating a single, unified view of data from multiple tables.

• Example: A common join in QlikView would be linking a 'Sales' table with a 'Product' table based on a 'Product ID' field.