Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone pls help me with script for incremental load
go through with the attached document. and example file
if any doubt , ask here
Hi Upali,
See attached document.
thanks,
Rajesh Vaswani
Hi
1. You can use QVD to store "old" data and then Load new data using WHERE statement or NOT EXISTS statement to load only new records from DB or files.
2. You can use partial Load (ADD LOAD) but it can be touchy if many temporary or related tables are involved.
best regards
Chris