Hello Gurus,
I have a requirement where I have to build a cube with multiple source. I have huge set of dimensions and a fact table. These dimension tables have surrogate keys and these are linked to the fact table.
For e.g., Product Dimension has 'Product_SK' which is a combination of Prod_Id, Prod_Line_Id, Prod_Type_Id, Prod_Grp_Id and Region Dimension has 'Region_SK' which is a combination of Reg_Id, Country_Id, State_Id, Cty_Id.
The Fact table 'Sales' has columns - Region_SK, Product_SK, Sales_Amount. If I am bringing them into my transformer for cube model, then my last level of diemnsion in dimension map will be Prod_SK for Products and Region_SK for Region.
Since they dont really have any meaningful detail, how do I avoid this SK's in my dimension. How do I go about constructing this cube. Please guide me with some useful tips.
Regards,
S