Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help to create un good data model with keys tables

Hi,

I have 4 tables :

Time (Temps), Store(Boutique),Sales(Ventes), Budget(Budget).

I would like to create a middle table (keys tables) to observe optimization model and Application.

Someone can help me to build my data model ?

In advance, Thanks.

1 Reply
Jason_Michaelides
Partner - Master II
Partner - Master II

Why do you want to do this?  Using a link table doesn't improve performance just by being there.  In fact I think link tables should anly be used if there is no other way to get the right result as they introduce more joins.  You should limit the amount of joins where possible and practical.

I think your model looks OK as it is.  You could maybe even join some of those tables into each other, but it's probably not necessary.

Hope this helps,

Jason