topic Re: Need help?? in QlikView

Need help??

paulwalker — Wed, 30 Apr 2014 09:21:01 GMT

Hi Community.

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

thanks in advance..

Re: Need help??

MK_QSL — Wed, 30 Apr 2014 09:26:14 GMT

Concatenate them.... or

Join them and delete any one

Re: Need help??

its_anandrjs — Wed, 30 Apr 2014 09:28:50 GMT

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.

Re: Need help??

Wed, 30 Apr 2014 13:07:47 GMT

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.