Archives of the TeradataForum

Message Posted: Tue, 23 Oct 2007 @ 15:09:35 GMT

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

Hi All,

I'am experiencing one unexpected behavior in Fastload.

I was trying to upload a table using Fastload. The file had some duplicate UPI which as expected were sent to the Error table 2 during loading.

     Total Records Read        =  903
     Total Error Table 1       =  0  ---- Table has been dropped
     Total Error Table 2       =  3
     Total Inserts Applied     =  900
     Total Duplicate Rows      =  0

I wanted the records with the latest update date to be loaded in my target table and the rest of the records to go to error table 2.

So, I sorted the file, in descending order with the Address update date field using the SYNCSORT in mainframes.

When I Fastloaded these sorted records, none of the records went to the error table2. It just showed me some dulpicate records.

     Total Records Read        =  903
     Total Error Table 1       =  0  ---- Table has been dropped
     Total Error Table 2       =  0  ---- Table has been dropped
     Total Inserts Applied     =  900
     Total Duplicate Rows      =  3

I am not loading the Address update date field in my target table. So, to make sure the record with the latest update field has been loaded in the target table, I changed some of the fileds of the record with the latest update date, which were being loaded in the target table. To my surprise now these records are thrown in the error table 2

     Total Records Read        =  903
     Total Error Table 1       =  0  ---- Table has been dropped
     Total Error Table 2       =  3
     Total Inserts Applied     =  900
     Total Duplicate Rows      =  0

*Also, in whichever order I sort, the records with the changed value (the fields which I changed) go to the Error Table 2. It appears that the Fastload is not loading the record as read in the file.*

One more question in addition to the previous one:

Fastload while determining the duplicate record, sees all the fields or only the fields which we are loading in the targert table?

I mean if there are 2 records

            field1                     field2
UPI         (loaded in target table)   (Not loaded in target tbl)

1234567     S                          A
1234567     S                          U

Will these be treated as Duplicate records or UPI voilation?

Regards,

Shubhangi

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