4.Explain Snowflkeschema ?
Answer Posted / samir kumar sahoo
In snowflake schema the dimension table(denormalized table)
will be further divided into one or more dimentions
(normalized tables) to organize the infomation in a better
structural format.To design snowflake we should first
design star schema design.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are various warehousing tools?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Explain Association algorithm in Data mining?
Difference between e-r modeling and dimentional modeling?
Explain what is a cube in data warehousing concept?
What are modeling tools available in the market?
What is difference between model & package?
Can you pass sql queries in filter transformation?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
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 347 what is hybrid slowly changing dimension?
How can we schedule the graph in unix?
What are the various tools? Explain name a few?
What is latest version of power center / power mart?
What is surrogate key? Where we use it? Explain with examples.
what is difference between drill & scope of analysis?