Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community.
if i have 2 transaction tables. how to create star schema data model.
thanks in advance..
Concatenate them.... or
Join them and delete any one
You can link them with another Key which is common in both otherwise Concatenate or join the two tables. I believe link them with another key which is both table or get the key if not available.
Paul:
If i understood correctly,
Do you have 2 fact tables with different granuality and connected to same or different dimensions.
if you will load these 2 fact tables then you will get a synthetic key.
Good way to create a datamodel for multiple fact tables is to create a link table.
Link table will have all the common keys from the 2 fact tables.
Drop these common fields from the individual tables after you create a link table.
Let me know if this helps.
