Data Warehousing - 2 Types of Tables

Different types of tables in Database : 

1  What is a  Dimensional Table?

This table contains the information in the dimensions.

Dimensions give the information about a measure or a fact. These are informational in nature. Eg: Geographic tables, Regional Tables, Time Tables etc.

In real-time the dimensional tables are generally has about few 100's of rows.

Dimensional Table will only contain the dimensions.

(No Facts at all)

Region ID	Location
10	Chicago
20	Detroit
30	Newyork

2.   What is a Fact Table (Measure)?

Tables that has the calculations and factual numbers are called Fact Tables.

 Fact Table will contain at least one fact column or measure of an dimension.

In real time, the fact tables have about millions of rows.

 Eg: Sales Tables, Profit and Loss Tables, Calculated Data etc

Which kind of tables are generally large in nature?

Fact Tables with million of records. ( One row for every transaction)

  

Sales Table (B) (Fact)

Sales Transaction ID	Sales Amount	Region ID
1450	13 USD	10
1350	25 USD	30
1234	45USD	10