|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/15/2009 5:21:23 AM
Posts: 1,
Visits: 13
|
|
Hi,
Please help.
How we can validate the Text file Data in teradata?
ex:
I have 100 records in source in loaded usng fast load .i got only 90 records in target.
tell me the falt file validation in teradata
Can you please help on this
Regards
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: Yesterday @ 7:15:08 AM
Posts: 7,
Visits: 67
|
|
Hi,
fast load creates the two error table and one log table. just checkout the error tables and the status of the report. if the status of the report is other then zero means some of the records are inserted into error table. fast load by default creates the error tables as tablename.e1 nd tablename.e2.
tablename.e1--->holds the translation error or constraint violation
tablename.e2---->holds the duplicate key violation error
Thanks
Rajeev T
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/5/2009 12:34:37 PM
Posts: 10,
Visits: 26
|
|
As said above fastload has two error tables ET1 and ET2 . You had 100 records to load and 90 records were loaded successfully. if your fastload job did not abend in this case it means your input file had 10 dups in it which are ignored by fastload while loading. if those 10 records had any translation/constraints error it would have been listed in ET1 and your job would have abended.
Cheers,
Samp
|
|
|
|