Archives of the TeradataForum

Message Posted: Thu, 13 Jul 2006 @ 21:12:57 GMT

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

Why are not processing these records in UV table? If they are error record, would not you like to store them in one common error/reject table?

Also if you are using any ETL tool then use a design pattern where only good rows will be able to go to target via MLOAD and rest of them can be captured in error/reject table. At the MLOAD level, set the error threshold to 0 rows.

Please let me know if your purpose is different for the data load.

Regards,

Roopali Doshi

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