updating is there what will u do in incremental load?

[#1]

updating is there what will u do in incremental load?

[suresh_rawat]

Hi,

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

Regards

Suresh Rawat

[#3]

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

[suresh_rawat]

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:

A,

B,

C

From TXT file

Concatenate

A,

B,

C

From Data.QVD

Store this file in Data.QVD

By this way you can create a Increamental Load QVD.

[#5]

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]

Hi Siva ,

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

for Example check out below link

http://community.qlik.com/docs/DOC-5317#comment-22454

[suresh_rawat]

Hi Siva,

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

[vardhancse · Accepted solution]

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.