Archives of the TeradataForum
Message Posted: Wed, 17 Oct 2007 @ 20:41:38 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|