when can i use the STAR Schema and SNOWFLAKE Scgena
Answer Posted / subbu
for huge amount of data snowflake schema is the best.and
for less amount of star schema is better
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
--------------Diff b/w ODS and OLAP?
What are all the components of Report Studio?
Explain difference between powerplay transformer and power play reports?
What r the names of the reports that you prepared?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
what is catalog and types of catalogs in cagnos and which is better?
Please explain the different stages in creating a report in cognos report net?
Tell me about Dnamic and Static Dashboards?
What is set to be Cognos configuration?
what is stitch query in reportnet?
Can you define folder?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the difference between low affinity and high affinity connections?