link table

[deepakqlikview_123]

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

[Peter_Cammaert]

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.

[datanibbler]

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