Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
my model based on 9 QVD's, 4 of them connected with a link table \ key table
I notice that when I add the key field to connect tables via link table (THE_DATE&'|'&CAMPAIGN_NAME&'|'&AD_GROUP&'|'&PLACEMENT AS G_PLACEMENT), Script Execution is going very slow and the QVD's are not optimized.
is there any way to optimize these 4 QVD's?
Thanks,
ilan
Hi ilan,
QVD load won't be optimized if you make any modifications to your load statement. The only function you can use is the "as" keyword to rename your fields.
I would recommend 2 things:
1) You can create this concatenated key when you create your QVD. you can then directly load these 4 QVDs in an optimized way.
OR
2) First LOAD all 4 QVDS, and then create the keys and join once these QVDs are in memory. This will make things faster as everything is in RAM.
Juan
String concatenation is VERY slow and you are also losing optimized loading [qlikview super fast load].
If you are just wanting a unique key then use
autonumberhash256(THE_DATE,CAMPAIGN_NAME,AD_GROUP,PLACEMENT) AS G_PLACEMENT,
This is many times quicker that concatenate string but will still not use optimized loading.
Be Aware:-This will give you a unique key but the key will be different after every reload. But the same within a reload for the same values.