topic Re: updating is there what will u do in incremental load? in QlikView

updating is there what will u do in incremental load?

Wed, 29 Oct 2014 04:06:56 GMT

updating is there what will u do in incremental load?

suresh_rawat — Wed, 29 Oct 2014 04:17:19 GMT

Hi,

Can you elaborate what your actual query is?????

Regards

Suresh Rawat

Wed, 29 Oct 2014 04:20:48 GMT

updating is there in db what will u do in incremantal load in updating qvd's?

suresh_rawat — Wed, 29 Oct 2014 04:26:57 GMT

Hi,

As per my understanding you want to know how Incremental Load Done in QV.

First, get the data from the datasorce(Excel, Query, Txt file Etc) and make a QVD of that data.

Then,(If data came daily from Text file)

Data:

From TXT file

Concatenate

From Data.QVD

Store this file in Data.QVD

By this way you can create a Increamental Load QVD.

Wed, 29 Oct 2014 04:55:41 GMT

see,

i want to update my qvd with latest data where customer name='xyz' and year='2009'.

how it can be done..how to set the flag values?

perumal_41 — Wed, 29 Oct 2014 05:16:01 GMT

Hi Siva ,

Incremental load will work only PrimaryKey and LastmodifiedDate filed based on.

for Example check out below link

suresh_rawat — Wed, 29 Oct 2014 05:19:20 GMT

Hi Siva,

In your data 1 filed have primary key based on that the data will update.

vardhancse — Wed, 29 Oct 2014 05:21:12 GMT

Incremental load will work on below process.

1.If QVD is not there ,then full load of qvd will be done.

2. If QVD is there, then incremental load logic will work out

for every table we need to add one additional field in the DB level called time stamp(it will tell the last updated time)

based on the time stamp field we can check the file in the QVD, based on time update/new record entry will be done.

Mostly in production level will do only create/update but deletion will not be done.

Hope this is help full to you.