Data Model question - keeping two source tables as it is with its natural joins - not joining or concatenating them - is it ok.

[Anonymous]

Hi I have a data model question.

I have two source tables and both will be connected to each other using a common field between them which will have the same name. The first table has all the dimensions and measures in them. The second table has all its dimensions and measures in them. They will just be connected to each other using one common field such as a Project number.

I plan to keep these two tables separate in qlikview just as they are as source tables. As they are already connected using a natural join of project number. Is this a fine approach as I plan to use this as the data model. Please let me know if I will get the right results if I keep them as it is instead of joining them as qlikview already has a link of the common field between them. I will try to keep a watch at the information and subset ratio to see what percentage that is so I get to know how much missing data in each table. Please let me know if it's good to go ahead keeping the two tables separate.

[luismadriz]

Hi,

Natural Join would be my default approach. Remember that Qlik associative model differs from regular SQL joins

You need to understand their granularity and their level of normalisation; or better yet the reasons why they are separate; for example, if one is one month and the other is another month I'd concatenate them.

I hope this helps,

Cheers,

Luis