Why denormalization is promoted in universe designing?
- 1 Answers
- 1067 Views
- I also Faced
- E-Mail Answers
Answer / Idreesh Ahamad
Denormalization is promoted in data warehouse design to improve query performance. By duplicating data from multiple tables into a single table, queries can be simplified and executed faster because they don't need to join multiple tables. However, denormalization increases the risk of data inconsistency if not properly managed.
| Is This Answer Correct ? | 0 Yes | 0 No |
1.WHAT IS DATA MART ?
Explain why are oltp database designs not generally a good idea for a data warehouse?
wht is degenerated dimension ?it's uses?
Explain which columns go to the fact table and which columns go the dimension table?
what are the other factors of the database on which the loading performance depend?
What are the design methods of data warehousing?
Explain grouped cross tab?
How many ways we test the universe & Report?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What are the types of SCD?
What is a Data Cube?
What is the difference between view filter and report filter?
Teradata 
