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
]]>