Please visit DEMANDDRAFT.SHOP for quality of products...

Ad

Search This Blog

Sunday, July 1, 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