Snowflake Schema: An extension of the star schema by means of applying additional dimensions to the Dimensions of a star schema in a relational environment. Snowflaking is a form of dimensional modeling; dimensions are stored in multiple relational dimension tables. A snowflake schema is a variation of the star schema. Snowflaking is used to improve the performance of specific queries. The schema is diagramed with each fact surrounded by its associated dimensions as in a star schema, and those dimensions are further related to other dimensions, branching out into a snowflake pattern.
QlikView Interview Question and Answers
QlikView application
QlikView Interview Question and Answers
QlikView Questions
Snowflaking Schema
Can you explain Snowflaking Schema ?
Saturday, 19 January 2019
Subscribe to:
Post Comments (Atom)
Recent
Weekly
-
QlikView provides a feature called Autogenerate which use for generate data using system’s programming. Using Autogenerate, QlikVie...
-
Keep: it will not join two tables and they will be stored in QlikView as two separate named tables. Keep will always preceded by one of th...
-
Optimized load is much faster and therefore preferable, especially for larger data sets. Optimized loads are possible if no transformations...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di...
-
To connect a QlikView server (QVS) each client needs a CAL (client access license) The CAL’s are purchased with QlikView Server and tied t...
-
No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables
-
ODBC, OLEDB, SAP connectors
-
1st Tier - Raw data is getting loaded and QVD is creating. 2nd Tier - QVD is transform in the business login and requirement of the bus...
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
0 Comment to "Can you explain Snowflaking Schema ?"
Post a Comment