Performance of load script

[luibill]

Hi all,

I want to know what is the best practice of data loading.

For example, I have a item master and item sales record at database.
Case 1: Load item master (item code and item name only) and item sales record to Qlik as 2 separate tables.

Case 2: Combine item master (item code and item name only) and item sales record by SQL script and load to Qlik as a single table.

What is the difference between case 1 & 2?  Which one will have better performance?

Thanks in advance.

Bill Lui

[vinieme12]

Case 2:  A single table will have better performance as no selections/filtering need to be propogated to another table 

However the most important thing when considering to combine datasets to is to see if it would cause duplicates in final table 

If one item code in sales table relates to more than one item in item master, then you will end up duplicating Sales data 

[vinieme12 · Accepted solution]

Case 2:  A single table will have better performance as no selections/filtering need to be propogated to another table 

However the most important thing when considering to combine datasets to is to see if it would cause duplicates in final table 

If one item code in sales table relates to more than one item in item master, then you will end up duplicating Sales data 

[luibill]

Thanks for your reply and explanation.