Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
Answer Posted / 9885657928
Snow flake schema
why because a denormalized dimentional table splitted into
one or more tables which results in normalization of
dimentions.It hempers the Query performance due to more
number of joins.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain what are the various file formats involved in reportnet?
I need to set predefined condition. How I do this?
What is pre-emptive and non-pre-emptive?
Store (and count) non-fact records?
What is "method/1"?
Explain what are the various transformation available?
What is latest version of power center / power mart?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
For faster process, what we will do with the universe?
Explain the difference between dw and bi?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
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 meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is mean by aggregate aware?
What is the difference between view materialized view and view?
In document how to create metrics?