Can someone pls help me with script for incremental load
go through with the attached document. and example file
if any doubt , ask here
See attached document.
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.
Retrieving data ...