SQL Server Performance

same key at Fact table link diff dimension table ?

Discussion in 'Analysis Services/Data Warehousing' started by tboonleong, Mar 8, 2007.

  1. tboonleong Member

    Let said a senario with this situation:

    Fact table contain 2 type data.1 st type is the company data and 2 nd is an individual data. In the fact table have a column called GenderID.

    Company data have to use GenderID key link to CompanyGender dimension table and individual data also use GenderID key to link Gender dimension table as well.

    p/s:In the fact table have the CategorID to identified either is company data or individual data.

    May I know how to handle this situation in the designing cube and linking between fact table to dimension table in cube as well?

    Thanks advance for helpng.
  2. whygh New Member

    I got same situation. Do you get solution?

    Thanks
  3. Raulie New Member

    Lets see if I undersand the question...you have two dimension FKs in your fact table that need to link to the same dimension table "CompanyGender"??? This is a typical scenario in which is handled by creating a "View" from the CompanyGender Table then linking it that way, this is common for "Time" dimensions where the fact table has many date columns.

    Raulie



Share This Page