Dimensional Modeling Concepts to Learn

To understand Dimensional Modeling ,
Following concepts are very very important

http://kimballgroup.com/html/kucourseMDWD.html

• Basic dimensional modeling concepts
• Conformed dimensions
• Slowly changing dimensions
• Additional concepts in dimensional modeling
-Hierarchies and snowflaking
-Degenerate and junk dimensions
-Many to many dimensions
• The dimensional modeling process

---------------------------------------------------------

• Populating dimension tables
-Using the slowly changing dimension wizard
-Avoiding the slowly changing dimension wizard

• Populating fact tables
-Basic fact table processing
-The surrogate key pipeline
-Advanced issues in fact table processing

--------------------------------------------------------------
A Good Link
http://kimballgroup.com/html/articles.html