Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
Answer Posted / prasant tripathy
Hi
star schema takes more space then the snowflake because
star schema is denormalised schema and snowflake is
normalised
Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
How to generate the cubes in framework manager?
What are Aggregate tables?
Explain what are the various reporting tools in the market?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain a mapping, session, worklet, workflow, mapplet?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
What is aggregate fact table?
What a static and local variable?
Explain normalization?
How to pivot data using informatica when you have variable amount of pivot rows?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
how much memory space occupied real time project (roughly)?
Explain what is the difference between a primary and secondary actor in use case modeling?
How can we do data cleaning?