PREVIOUS

How many types of approaches in DHW?

Two approaches: Top-down(Bill-Inmon approach), Bottom-up(Ralph Kimball).

Explain Star Schema?

Star Schema consists of one or more fact table and one or more dimension tables that are related to foreign keys.

Dimension tables are De-normalized, Fact table-normalized.

Advantages: Less database space & Simplify queries.


Explain Snowflake schema?

Snow flake schema is a normalize dimensions to eliminate the redundancy.The dimension data has been grouped into one large table. Both dimension and fact tables normalized.


What is confirm dimension?

If both data marts use same type of dimension that is called confirm dimension.If you have same type of dimension can be used in multiple fact that is called confirm dimension.

NEXT