MSBI -- Data Warehousing Concepts -- Part-6

Dimension and Fact Table

Dimension Table:

1.     The table which stores Master data OR Organizational level data is known as Dimension table.

2.     Each record in this table gives a complete description of a particular entity.

3.     The Dimension Table data will not change frequently but over a period of time dimension table data also changes.

                 

Fact Table:

1.     The table which stores actual day-to-day business transactional data is known as Fact table.

2.     Each Record in this table is a business transaction at particular point of time.