Fact Constellation Schema is describes a logical database structure of Data Warehouse or Data Mart. Fact Constellation Schema can design with collection of De Normalized Fact, Shared and conformed dimensional tables. Fact Constellation Schema is an extended Decomposed Star Schema.
QlikView Interview Question and Answers
Fact Constellation Schema
QlikView Interview Question and Answers
QlikView Interview Questions
QlikView Questions
What is Fact Constellation Schema?
Thursday 27 August 2015
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...
-
ODBC, OLEDB, SAP connectors
-
Set: this command assigns the variable the text to the right of equal sign. Let: assigns the variable whereas Let command evaluates...
-
No Concatenation: if the two tables have same fields also No Concatenate treats as separate internal tables
-
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...
-
Boxplot The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the di...
-
Information density of the field, which indicates the percentage of rows that contain a non-null value Subset ratio, which shows the ...
-
Binary load is used only for one application means you are able to read data from only one QVW application and on the above of the set scr...
0 Comment to "What is Fact Constellation Schema?"
Post a Comment