Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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
Luminary Alumni
Luminary Alumni

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