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.
(Continued on next question...)
(Continued on next question...)
No comments:
Post a Comment