Archives of the TeradataForum

Message Posted: Tue, 13 Sep 2005 @ 17:37:14 GMT

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

Unfortunately I dont know anything about informatica but you might want to check the data types of the columns.

Oracle supports some different types (and maximum sizes) than Teradata so maybe it is having a hard time trying to figure out what to use.

If the number of columns is the same in both tables the error message seems like the wrong one though.

Does Informatica require you do do something special for Null values maybe?

If the data does not contain strings with carriage returns in them you could try using SQL Assistant to export the data to a delimited text file and then use its Import mode to load it back into Teradata. (Not optimal for performance - but it should work... and I could look at a couple of rows of the data if you still get the same problem. Note that you should set the Export option to 'Not' write out the column headers. If you have an older version of SQLA without that option you would have to edit the file to manually remove the first line of the file before Importing it.)

Mike Dempsey
Teradat Client tools

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