Fastload -- doubt.. help required


Fastload -- doubt.. help required

ouput report :

A Total Records Read = 35000
B Total ErrorTable 1 = 1250 (Not loaded due to error)
C Total ErrorTable 2 = 30 (Duplicate UPIs only)
D Total Inserts Applied = 33700
E Total Duplicate Rows = 20

i am confused with "duplicate rows" and "error table 2 rows"
according to what i understand :

"error table 2 rows" : 15 records which have dups in UPI so pairs make it 30

"duplicate rows" : after checkpoint and before the point where error reached its limit ..

can anyone please help me clear this doubt ?


Tags (1)
Teradata Employee

Re: Fastload -- doubt.. help required

The two Error Tables are populated with rows for different reasons and those error tables are controlled and populated by the Teradata DBS. Not by the client.

Error Table 1 contains rows that had errors during the Acquisition Phase (the actual sending of data to the DBS). Those errors are usually due to data conversion errors.

Error Table 2 contains "UV" (uniqueness violation) errors. Those errors are detected during the Application Phase (also known as Phase 2).

Duplicate rows are silently discarded by the DBS and do not factor into any of these number. However a row in the second error table usually means a row had a uniqueness violation of the UPI.

FastLoad takes the number of rows read in, subtracts the number of rows in the 2 error tables, then subtracts the number of rows actually applied to target table. Anything left over means there were rows that did not end up in the error tables or the target table and therefore must have been silently discarded by the DBS, and the reason for that must have been because they were duplicates.

Error Table 2 shows "30", not "15". There were 30 rows that violated the uniqueness condition. There are no "pairs" in the equation.

Those numbers all appear correct.

-- SteveF