Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have set up incremental load for each tables and store them to QVDs. Now the problem is if s/w people add any a new field to existing tables on org. database then how do i implement a new field on existing table during incremental load?
Thanks,
Does anyone have any insight on this?
Thanks for any help!
One method will be to load the data of the previous version of the qvd file, add the new column(s) and create a new qvd.
After this you can follow whatever procedure you were previously following for the incremental load.
When you load the previous QVD you can use the concatenate command to force the concatenation, even if you have different fields.
Then, this field will be a null for the old records.
both options were on my mind but just wondering is there any other method. thanks for the help!