Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What is mean by the incremental load .Could you pls Explain me Briefly
Thanks in Advance
Regards
Raviteja
Extract into QVD's only the changes from the db, not all the transactions.
You use a field that contains the timestamp of the last change. If you don't have one, you decide which transactions needs to be extracted. For example, there is no point in getting the previous years, you will always have the same transactions.
In the reference manual, this is IMHO quite well explained. Search for chapter 'Using QVD files for incremental load'.
I think it's chapter 28.4
1. Stored the previous load as a qvd
2. Load the previous qvd
3. Get max date from previous qvd
4. Load the new data (csv file) where date is greater than max date from previous loaded qvd file.