Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bhaskar.nagi
Star Schema: Star Schema contains Centrally located Fact
table sourended by Dimension Tables. So Data Base design
looks like a Start. Fact table contains the fact information
at the lowest level granularity. Fact table contains Foreign
keys and Dimension Table contains Primary key.
Snow Flake Schema: In a star schema, if a dimension table is
spleted into one or more dimension results in normalization
of dimensions. Since the database design looks like snow
flake structure.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Explain what is the difference between microstrategy and cognos reporting tool?
What is defined as data mining?
Define report item?
What is called cognos reporting tool?
What is the difference between regular dimension and derminant?
how to connect datamarts
what is the difference between filter and condition?
What are cognos connection initial page components?
How the Bursting happens in same report and how to Print the bursting Report?
---------------Describe OLAP Reporting and RDBMS Reporting?
Can you define materialized view?
Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.
How is possible this scenario using in type-in prompt.?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
what is the main advantage of impromptu over cognos reportnet?
