FactTable and Dimension table Identification

  • Hi

    How to Identify that fact table and Dimension table.

  • What do you want to know?

    Dimension table has the lookup field of the system eg, customer, product....

    Fact table has the measure (number) and has the dimensions in it. This is the main different.

    If you don't understand, I recommend you read some data warehouse book, it is the basic of the data warehouse.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply