topic Incremental Load in QlikView

Incremental Load

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

Hii,

I am doing incremental load for one of the application.

All the data are coming from SQl database.

I have 3 tables on which I want to apply incremental load. So hat i have to do.

Wheather first store in QVD and then apply where exist on it or before storing it in QVD apply where exist on it.

while i am applying where not exist before storing it in QVD that is while loading from SQL function where not exist want work ?

so i am confused in it. can anyone can help me.

arvind_patil — Fri, 11 Aug 2017 09:36:48 GMT

Hi Dhaval,

You Need to fetch only those records which are new. Then concatenate it with old Qvd and Then Store into qvd.

Thanks,

Arvind Patil

its_anandrjs — Fri, 11 Aug 2017 09:36:56 GMT

Hi,

First of all understand what is the process of the Incremental load basically it would be three types

1. Insertion Only

2. Insert, Delete Only

3. Insert, Delete and Update

Have on this threads

Regards

Anand