Warehouse Concepts Question: Download Questions PDF
Explain Why Denormalization is promoted in Universe Designing?
Answer:
In a relational data model, for normalization purposes, some lookup tables are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called DIMENSION table for performance and slicing data.Due to this merging of tables into one large Dimension table, it comes out of complex intermediate joins. Dimension tables are directly joined to Fact tables.Though, redundancy of data occurs in DIMENSION table, size of DIMENSION table is 15% only when compared to FACT table. So only Denormalization is promoted in Universe Desinging.
Download Data Warehouse Concepts Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is cubes? | Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool? |