Please create a perfect datamodel for the below data

[#1]

Hi i have a 3 dimension tables and 2 fact tables which was converted in to qvds and loaded to create a perfect model .Can any one  Please create a perfect data model without any association and synthetic keys for the below given data and please explain the script, Thank you in advance

[Clever_Anjos]

your model is empty

[#3]

Hi Mahesh

your data model is empty.i think forgot to reload the application . reload it and upload the doc..again

[clondono]

Hi Mahesh,

To avoid synthetic keys in your data model you can create a Link table to avoid circular references and to join the two fact tables in your model.

Refer to this blog for discussion about Link Tables:  Concatenate vs Link Table

Hope this helps,

Carlos