Circular reference/loops:
There are more than one path of association between two fields below are the ways to remove.- Alias
- Qualify
- Link table (join)
- Concatenation
Weekly
-
Star Schema: In a star schema, the fact table will be at center and in connected to dimensional tables. The tables are completely in De...
-
RDBMS: stands for Relational Database Management System. It organizes data into related rows and columns. It stores data in Tables havin...
-
We can load data from ODBC, OLEDB, SAP connectors by connect, select statements and also we can load flat files like excel, word, xml etc… ...
-
What is the use of Cross table prefix in QlikView Load Script? What is the difference between Map Using and Mapping Load? Synthetic Keys ...
-
For Optimization we can optimized the QVD which is used in the QVW files in the backend. For QVW optimization I believe not use any tools w...
-
What are the multiple protocols defined for client communication with QVS? Explain different communication encryptions for Windows Client...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di... -
Returns a set of values of expression calculated over dimension Ex: Aggr(sum(sales), country)
-
The architecture is based on site concepts. It is a combination of one or more node connected to a common repository or central node. Ql...
-
Self-provider records conception utility that enables you to look and determine vast amounts of facts to find out visions of the employer....