Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
your model is empty
Hi Mahesh
your data model is empty.i think forgot to reload the application . reload it and upload the doc..again
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