topic Re: link table in QlikView

link table

deepakqlikview_123 — Thu, 26 Feb 2015 12:20:21 GMT

Hi All,

Please find below image.

As per my unserstanding

link table contains comman fields between two or more tables.

Moreover contains foreign keys.

But in attached image dimension table related to fact tables are directly connected to fact tables not to central link table.

Can you please suggest is this right approach or all dim table also connected to central link table.

Thanks

Re: link table

Peter_Cammaert — Thu, 26 Feb 2015 12:38:21 GMT

If the dimensions connected to the facts are not present in both facts tables, leave them where they are. They will filter the table they are connected to, and by association also the other facts table.

If these dimensionss are real common dimensions, move them to the LinkTable. Otherwise they will produce unwanted filtering.

Do these two facts tables have a header-detail-sort-of-relationship? Then you may not need a link table at all.

Re: link table

datanibbler — Thu, 26 Feb 2015 12:40:32 GMT

Hi deepak,

if all of those dimension_tables you have have just two columns, as it seems in your image, wouldn't it be easier to join them all into the respective fact_tables?

Apart from that, there is no fault in that data_model. On the contrary - if those dimension_tables were also connected to the central link_table, you would run into problems with links between tables where you don't want them.

HTH

Best regards,

DataNibbler