Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
Thanks for your reply and explanation.