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 important features of Qlik Sense? Drag-and-drop visualizations Scalability and Manageability Powerful Open and Standard A...
-
Optimized load is much faster and therefore preferable, especially for larger data sets. Optimized loads are possible if no transformations...
-
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...
-
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 are the multiple protocols defined for client communication with QVS? Explain different communication encryptions for Windows Client...
-
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...
-
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)
-
There are eight types of searches in QlikView: Associative search Advanced search Compound search Expression search Fuzzy search ...
-
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