Archives of the TeradataForum

Message Posted: Wed, 17 Oct 2007 @ 20:41:38 GMT

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

Hi All,

I want to load the data from a work table to my target table. Whenever a duplicate UPI occurs I want to load the record that has been read first and reject the others with same UPI.

Is there a way of finding out which record has been read first?

I want to do, what exactly a fastload does while loading data from file. If a duplicate UPI occurs it loads the first record to the table and sends the rest to Error tbl 2.(If I am correct in my understanding).

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