What is the main difference between star and snowflake star schema? Which one is better and why?
- 0 Answers
- 556 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is the metadata extension?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What are diagrams?
0 Answers InfoAxon Technologies,
How can we run the graph? What is the procedure for that?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is static and local variable?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
Why denormalization is promoted in universe designing?
5.Explain ODS ?
Is there any rownum object from which we can do this?
Give me a broad concept of what a data warehouse is, and what it might be used for?
what is the difference between aggregate table and fact table ? how do you load these two tables ?
Teradata 
