When should you use a STAR and when a SNOW-FLAKE schema?
Answer Posted / shivaleela
STAR SCHEMA:-if PERFORMANCE is the priority than go for
star schema,since here dimension tables are DE-NORMALIZED
SNOW-FLAKE SCHEMA:-if MEMORY SPACE is the priority than go
for snoflake schema,since here dimension tables are
NORMALIZED
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
Difference between e-r modeling and dimentional modeling?
What is static and local variable?
How to generate the cubes in framework manager?
what are the others of "bad files" and "discard files" when using sql*loader?
What do you mean by static and local variable?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Explain er diagram?
Define data warehouse?
Can you brief about the Data warehouse project you worked on?
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?
Explain how many ways you create ports?
What is the difference between view filter and report filter?
Explain what are the various file formats involved in reportnet?
Explain what are the modules in power mart?
What are components of report studio?