Archives of the TeradataForum

Message Posted: Wed, 11 Feb 2009 @ 21:12:07 GMT

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

Michelle:

You keep saying that they are "dropped." Have you tried exporting them from Error table 1? This would identify the ones that are not correct and you could either:

1. load these bad dates into your table - all with null or

2. load them into a staging table and then insert/select them from the staging table into the production table

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

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