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.
Saturday 19 January 2019
Subscribe to:
Post Comments (Atom)
Weekly
-
QlikView provides a feature called Autogenerate which use for generate data using system’s programming. Using Autogenerate, QlikVie...
-
Optimized load is much faster and therefore preferable, especially for larger data sets. Optimized loads are possible if no transformations...
-
ODBC, OLEDB, SAP connectors
-
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...
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
Qlikview Generic Load is the load which is used in Qlikview for Generic database. Generic database is used in Qlikview to define the table...
-
The way in which QlikView's associative engine works means Nulls don't really exist in the data it holds, a Null is simply an absen...
-
What is Distribution Plot in Qliksense? It is great for displaying dimensional data points distributed along a horizontal line by the ex... -
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
-
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...
0 Comment to "Can you explain Snowflaking Schema ?"
Post a Comment