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
what are the features in cognos8ui
where you can save the report net documentation in our local system?
What is the size of database for you project?
how to perform single sign in cognos by using url?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
Can you define metrics designer?
--------------Diff b/w ODS and OLAP?
How we check the errors before running the report?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What do you understand by the term 'aggregate cache'?
What you mean by drill across?
What is the complex report you faced in real time?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is an olap designer?
What are the components of the report studio?