Incremental load

[#1]

Hi,

I have atached script of incremental load. From that I am getting only Qvd data which is history. But I should also get incremented data along with history.

I may went wrong in applying peek function. So please suggest me after looking into the script attached.

Scenario.

I have the data in the Qvd from 2011-Nov-23 to 2012-Dec-02.

In the databsae I have full data i.e upto 2012-Dec-03.

I am not getting output for incremental data i.e for 03-Dec data . Currently I am geting data as there in the QVD. Not incremental happening to add up one more date value.

Kindly respond.

[#2]

Hi,

As it really helps a lot if I can get the solution from community. Awaiting for the response. \

Thanks in Advance.

[gandalfgray]

So what does the vIncrementalExpression variable contain?

What do you get when you use that where clause directly in sql?

[#4]

where clause wil get the results of those records which are new data. In my case it is 03-Dec-2012 data.In the script u can see. I am comparing timemodified of db table with maxloaddate of qvd.

[farolito20]

Do you resolve that?

I have the same problem

[#6]

I have slightly changed the script as per my requirement. Hope the attached script will help.

[#7]

Sorry forgot to attach file early.

[farolito20]

The same script at the first post?

[#9]

No. Its different. But it solved my problem. Its insert and update method of incremental.

[#10]

Its insert and update method of incremental. The script posted now and earlier are different. The recent posted script solved my issue.