How to apply Incremental Load on QVW file (Not on QVD)?

[#1]

Hi,

I want to apply an incremental load on qvw file not on qvd.

I had already applied an Incremental load on qvd.

When I reload my QVW file for first time it should contains the latest 25 days data and then on the next day when i again reload that qvw file it should delete the first day data and append only latest 1 day data.

Eg:- When I reload QVW for first time it has data from 05/12/2013 to 30/12/2013.

When I reload that QVW file on 31/12/2013, So it should delete the data of 04/12/2013 and append only one day data i.e, of 31/12/2013.

Is this Possible??????

[chiru_thota]

I guess it is possible.

But it not like deleting and adding last date.

You can have one more columns in QVD with like DateNo.

While loading from QVD , always load from last 30 by using that column (DateNo). 

[#3]

Thanks for your response....Chiranjeevi

But I want to apply Incremental Load.

Because whenever i will reload it will fetch all 30 days data.But I want to Fetch only latest 1 day data.

Is that possible...on qvw file (not on qvd).?????

[sunilkumarqv]

Yes Piyush ,

we can do it change the Date.

In script

Load

Day(Date) as Day do it same manner

[#5]

I am sending u my qvw file.

Please do the needful changes.....

Thanks....

[sunilkumarqv]

Find attached check it and tell so i will see alternatives for that

[#7]

Thanks Sunil.....

[Anonymous]

Hi PiyushKumar,

Why you want to apply Incremental load on qvw . It may be easily on the qvd by using incremental load we can fetch last one day of data.

The process is as below

sort the qvd  and in the qvd use order by date field.

then pick the last updated date by using the Peek('datefield',-1,tablename) and store last date in a variable like that

let vVar1= Peek('datefield',-1,tablename)

set vVar2 = $(vVar1)

then load the updated qvd by using where clause as example

where date >= $(vVar2 ) and date  < $(vVar2 )

by this condition we can get the last day of record then concatenate the previously loaded qvd .

I think this would be helpful for u .

thanks

[#9]

Hi Dhiraj,

I am having too much data.So instead of reloading whole data of one month.I just want to append 1 day data in my qvw file.So It will reduce my reloading time...

Is it Possible.?????

[sunilkumarqv]

Change where condition like below

where  Date> 'FromDate' and  Date<'ToDate';

Hope you will get solution