Fact & Dimension

[Anonymous]

What is the difference between fact and dimension? how come to know which one is dimension and which one is fact?

thank you.         

[Anil_Babu_Samineni]

Try in google so that you will get lot and lot information which related. Surfing should be Fact Vs Dimensions in Data model and go to images from the under tabs

May be helps Facts vs. Dimensions: Business Intelligence

[Anonymous]

its tough to understand me.. please any other explaination about fact and dimension.

[Anil_Babu_Samineni]

Oh, May be look these images for better understand

From Above Data model, It's clear

Above another snap, Check whether which is fact as you capture very first time. Off course, Here 5 tables are single tables which associated to Fact table. And then each dimension called one Field like Ename, Sal, Deptno ....

[#5]

Hi

Fact:

Fact Table contains the measurable attribute of the data. It contains measurable data that can be analyzed by Dimension tables. Fact tables contain the foreign keys of the associated Dimension tables.

Dimension:

Dimension Table Keys Are Connected With the Fact Table

first Load The Dimension tables then facts

[Anonymous]

Thank you Anil

[Anonymous]

Thank you kiran ,now my doubt is cleared.