topic Re: How to handle TWO Condition check for Optimized Loading in QlikView

How to handle TWO Condition check for Optimized Loading

vengadeshpalani — Wed, 25 Nov 2020 16:16:04 GMT

Hi all

I have 1 billion records in Fact.qvd I want load QVD as the Optimized format but I need to check two conditions how I want to handle this?

load Date

from Qvd;

load ID

from Qvd;

Fact:

load Date,

ID,

some Other fields

from fact.qvd where Exist (Date) and Exist (ID);

Re: How to handle TWO Condition check for Optimized Loading

prieper — Tue, 05 Dec 2017 11:48:52 GMT

Can you concatenate Date and ID in your datamodel?

Re: How to handle TWO Condition check for Optimized Loading

vengadeshpalani — Tue, 05 Dec 2017 12:03:18 GMT

Thanks for response

I use existing QVD if I want to update, it takes 30 hours.

do you have any alternate solution?

Re: How to handle TWO Condition check for Optimized Loading

marcus_sommer — Tue, 05 Dec 2017 12:10:01 GMT

You could use two load-steps - the first one optimized with one where exists() and a second resident-load with the other where exists() - the stronger filter should be applied first. I could imagine that it could be significantly faster than an unoptimized load and mybe it's sufficient for your task. Otherwise you will need to go with the suggestion from Peter.

- Marcus

Re: How to handle TWO Condition check for Optimized Loading

Anil_Babu_Samineni — Tue, 05 Dec 2017 12:31:30 GMT

If you load 2 different table, May be Nullify can fetch. So, You need to understand the difference b/w Join and Concatenate.