Archives of the TeradataForum

Message Posted: Wed, 29 Jan 2014 @ 10:42:22 GMT

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

Hi,

I've a table which is being loaded through Informatica ETL tool. One column in the table is defined as PERIOD(TIMESTAMP(6) WITH TIME ZONE). There is no such datatype i found in the ETL tool. As the field is straight move from the source(flat file), I've made the datatype CHAR(72) in the ETL Tool.

Now the ETL tool is making the MLOAD script dynamically(Loader Connection) and it's declaring the datatype of the column in the script as CHAR(72).

During MLOAD, the conversion from CHAR to PERIOD should be done appropriately but it is throwing the error : "UTY0805 RDBMS failure, 6996: Invalid conversion or assignment operation on a Period." So MLOAD is not able to convert the data.

Note: We can insert the data manually through SQLA in the same table with same value. That ensure the data is correct and the DDL is also correct.

TD version: 14.10.01.01

Could you please help me regarding this error?

Regards,

Koushik Chandra

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