Datamodel

[rupaliqlik]

Hi Experts,

Here is my datamodel which contain synthetic key but don't know how to resolve this issue.Linktable will work here?

[dplr-rn]

Link table may work but synthetic key s are effectively link tables that qlik creates automatically.

I dont know if there will be any performance benefits using link tables. You will need to try and see.

synthetic key (simple ones) it self does cause performance issues but looking at the data model it points to a data modelling issue. maybe you need to combine a few of the tables together.

to put simply there is no easy answer.

[rwunderlich]

Do the rows represent employees enrolled in those plans, or are they just plan data?

-Rob

[Brett_Bleess]

Have a look at the following Design Blog post, believe it should help you sort out the synthetic keys:

https://community.qlik.com/t5/Qlik-Design-Blog/Synthetic-Keys/ba-p/1472634

Here is the base Design Blog link in case you want to search for other posts that may be helpful on your own:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[jduenyas]

If all tables are supposed to be linked, create a unique field that is common for all of them by which they will be connected and rename each of these common fields specifically to each table. You cannot have the same column names appear in multiple tables because Qlik links table by fields that are named alike.