Thursday, March 3, 2016

Dimension Table VS Fact Table in Kimball DWH

Dimension tables contain descriptive information about a subject or matter. 
Dimension tables contain hierarchies of attributes that aid in summarization. 

For example, 
A "Student" dimension table contains descriptive information about Student -> (Name, Age, Gender, Address, Phone_No etc.)



A class dimension table contains descriptive information about class -> (Class_Name)



and a Subject dimension table contains detail information about subject -> (Subject_Name).



Note: Dimension tables contain attributes that describe fact records in the fact table.

Fact table contain summarized data to provide useful information to the analyst. 
The fact data is a relation/ Referential integration between various Dimention(Subject) Table data.

Here we can see it is a collection of only ids of other dimension Tables and forms useful information to the analyst.

So, from this table we understood following details given below:




  1.  Pritam Das is studying in class "Spoken English" and "Hindi" with subject "ABC Tutor" and "Hindi Tutor".
  2. Rina Das is studying in class "Hindi" with subject "Hindi Tutor"
  3. Ramaprasad Das is studying in class "Spoken English" and "Bengali" with subject "ABC Tutor" and "Bengali Tutor".





No comments:

Post a Comment