Post reply

Do I need primary ID in fact table?

  • September 4, 2008 at 5:54 am

    #197273

    I understand using primary key in tables for OLTP. But in case of DW I don't understand the use of primary key in fact table. It should have clustered key for a column used for range operation. Appreciate your further response explaining real purpose of primary key like ID (identity) in fact table.

    Regards - JL

  • September 5, 2008 at 5:11 am

    #867664

    I went through a lot of topics by Ralph Kimball and found that primary key is not used in fact table. This is because the fact key will not be used by any other fact. The fact table should contain foreign keys with dimension tables and actual measures.

    Thanks - JL

    Regards - JL

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

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