Hi
I have multiple dimension table where each dimension tables has 4 keys and the fact table also has the same and it is creating as many synthetic keys for each.
For ex:
i have 3 tables with same columns so i want to create a data model as star schema how can i do this? ..... i want star schema model.
TableA ( DIMENSION1)
Id1
id2
id3
id5
E
F
TableB ( DIMENSION2)
id1
id2
id3
id4
G
H
FACT(F1)
id1
id2
id3
id4
Revenue
sales
FACT(F2)
id1
id2
id3
id4
Loss_revenue
Loss_sales
Etc.
How we can do the datamodeleing eliminating synthetic keys for the same. give some examples where if any one handled multiples keys between multiple dimension and multiple facts and removing synthetic keys.