how to avoid synthetic keys while using role playing dimensions and Fact
table, I have seen few posts how to avoid use link tables, but that would be useful if I have common fields in 2 Fact tables, but I want to use dimensions and Facts.
Eg:
FactsTables:
SalesAmount
Taxamount
SalesDate
ShippedData
OrderDate
DimensionTable:
Date
Year
Month
Date as SalesDate
Date as ShippedData
Date as OrderDate
I need to resolve this issue for multiple dimensions, not only for Date Dimension, I have seen Canonical Calendar Post from HIC which was excellent post . It will be similar to that, but for other dimension I can't create common . With your Immense experience, could you help me, this would be useful to many people like me.
Many Thanks