Q2 : Explain QlikView architecture?
A : QlikView deployments have three main infrastructure components: (Check for Qlikview Architecture)
1.QlikView Developer: Is a Windows-based desktop tool that is used by designers and developers to create
1) a data extract and transformation model and
2) to create the graphical user interface (or presentation layer).
2.QlikView Server (QVS): Handles the communication between clients and QlikView applications. It loads QlikView applications into memory and calculates and presents user selections in real time.
3.QlikView Publisher: Loads data from different data sources (oledb/odbc, xml, xls), reduces the QlikView application and distributes to a QVS.
Because QlikView Server and Publisher have different roles and handle CPU and memory differently it’s considered a best practice to separate these two components on different servers.
Q3 : Explain QlikView Resident Load?
A : Create a new logical table in QlikView, based on a previously loaded (resident) table.
Q4 : Explain about Normalized Data?
A : Well Structured Form of Data, which doesnt have any repetition or redundancy of data. Its a kind of Relational data. Its mainly used in OLTP kind of stuffs Denormalized Data – Its a whole bunch of data without any relationship among themselves, with redundancy of data. Its mainly used in OLAP kind of stuffs.
Q5 : What is Central Link Table?
A : In the event of multiple fact tables QlikView In-Memory Technology allows us to create a central link table that only contains the existing data combinations. Instead of Joining the tables the event dimensions can be merged (CONCATENATED) in to one central Link table. This link table can then be linked back to the event measures one side and the dimension tables on the other.
Q6 : What is Container ?
A : A container object can be used to hold multiple charts. You can use a container object to put multiple charts in the same box. All charts will appear in the same window but only one chart will appear active at a given time. You can click the chart title to switch or toggle between charts. A word of advice: Use containers with caution. They form linked objects and might affect the properties of all linked objects.
Q7 : Define Join and its Types?
A : Join is used to transform the given data and whenever using joins to transform the data it is called Data Merging. Join will have different types as mentioned below:
Left Join, Right Join, Inner Join and Join
Q9 : How does Join Works?
A : An operation that uses two tables and combines them into one. The records of the table produced are combinations of records in the two original tables, usually such that the two records contributing to any given combination in the produced table have a common value for one or several common fields, a so-called natural join. In QlikView, joins can be made in the script, producing logical tables. Inner join, Left join, Right join and Outer join are all possible operations.
Q10 : What is binary load ?
A : Binary load is loading data from another QV file. For example, you have application A.qvw. You can create another application B.qvw with script binary A.qvw. binary file where:
file ::= [ path ] filename
Examples:
Binary customer.qvw;
Binary c:qvcustomer.qvw;
The path is the path to the file, either absolute or relative to the .qvw file containing this script line.
Q11 : What Is Star Schema?
A : The simplest form of dimensional model, in which data is prearranged into facts and dimensions is known as Star Schema.
Q12 : What is Left Join?
A : The join and keep prefixes in the QlikView script language can be preceded by the prefix left.
If used before join, it specifies that the join between the two tables should be a left join. The resulting table only contains combinations between the two tables with a full data set from the first table. If used before keep, it specifies that the second table should be reduced to its Common intersection with the first table before being stored in Qlikview.
Q14 : What is the Right Join?
A : The join and keep prefixes in the QlikView script language can be preceded by the prefix right. If used before join, it specifies that the join between the two tables with a full data set from the second table. If used before keep, it specifies that the first table should be reduced to its Common intersection with the second table before being stored in QlikView.
A : Each data warehouse consists of dimensions and measures. Dimensions allow data analysis from various perspectives. For example,