what is fact table in data warehousing
  • what is fact table in data warehousing
  • 1 Comment sorted by
  • fact table normally contains foreign key of other table and major like sum of sale amount etc.
    for example
    fact table
    --------------
    Product_Id (fk)
    Date_Id (fk)
    SaleAmount

    dimensional table product
    -------------------------------------
    Product_id (pk)
    Product_Name
    Product_Size
    etc etc

    dimensional table date
    --------------------------------
    Date_id (pk)
    Date
    month
    year
    etc etc

Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week