same key at Fact table link diff dimension table ? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

same key at Fact table link diff dimension table ?

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.

I got same situation. Do you get solution? Thanks
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