Archives of the TeradataForum

Message Posted: Thu, 14 Dec 2006 @ 19:41:55 GMT

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

There are a couple of things that could be wrong. The source data may not be formatted correctly, mm/dd/yyyy, when teradata is expecting yyyy-mm-dd. If you've built a transformation in Informatica, it may not be receiving/sending the expected format.

If your certain the incoming data is correct, and the format is adheres to your Informatica Source, TrnsFrm and Target defs, try defining your Informatica target field as char(10). Leave the actual table in Teradata alone, but define the target in Informatica as char(10).

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