Pages

Men

rh

7/01/2012

Star Schema and Snowflake Schema in SSIS


Star Schema:
It consist of one or more tables , one or more dimensions table that are related to the foreign keys.

Snowflake Schema:
It is normalized dimensions to eliminate the redundancy. The dimensions data has been grouped into one large table.

No comments :

Post a Comment