Archives of the TeradataForum

Message Posted: Wed, 19 Oct 2005 @ 10:06:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

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

Cheers

Suresh

	<Prev	Next>		<<First	<Prev	Next>	Last>>