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.
Thursday, 27 August 2015
Subscribe to:
Post Comments (Atom)
Weekly
-
What are the multiple protocols defined for client communication with QVS? Explain different communication encryptions for Windows Client...
-
What are the important features of Qlik Sense? Drag-and-drop visualizations Scalability and Manageability Powerful Open and Standard A...
-
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...
-
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 ...
-
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)
-
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...
-
Explain Aggr Function? What is the use of First Sort Value in QlikView? What are Set Modifiers and Set Identifiers? What is P() ...
-
Another way to comprehend this architecture is through a tier model. There are three tiers or layers of this model. In the first tier, t...
0 Comment to "What is Fact Constellation Schema?"
Post a Comment