Need help??

[paulwalker]

Hi Community.

if i have 2 transaction tables. how to create star schema data model.

thanks in advance..

[MK_QSL]

Concatenate them.... or

Join them and delete any one

[its_anandrjs]

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.

[#4]

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.