Incremental load

[smilingjohn]

HI All ,

PLease find the attachment of the QVW file  and QVD file..

Scenarion : Data will be fetched every 12 hours ...  Every tweleve hours some new recods will be cnahged or updated.

If i use the Last updated peek of load date then  i dont know how will it work because i need to add the changes records also

and this changes will be made twice in the same date .

How can  i add insert and update  only incremental load  to this ?

Can someone please help me on this ?

Thanks and regads

[krishna20]

Hi John,

I made necessary changes in the shared qvw.

Regards

Krishna

[smilingjohn]

Hi Krishna,

THnaks for the reply..

I have a doubt here ....

you are considering the max(load_Date) ... my question is .th data will be loaded two times within the same date (twice in 12 hours)  ..

How will this recognise the changes being made or new recods being updated ? 

Thanks

[krishna20]

Hi,

PFA, done changes only for Insert and update.

Regards

Krishna

[krishna20]

Hi

Attachment missed.