Archives of the TeradataForum
Message Posted: Wed, 19 Oct 2005 @ 10:06:59 GMT
Currently we are using Multiload Upsert logic to load the data into the target which are non history tables.
Now we have a specific requirement to maintain history and most of the tables will be converted into history treatment tables and I don't want to change the whole logic of coding by having the staging data in a work table and then comparing against the target table to find the records to close and insert the record which got changed.
Is there a way in the Multiload Upsert operation that if a record is marked for update, that particular record should be closed (basically update the end_Date) and the corresponding update row to be inserted as a new record.
Any help is appreciated
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|