Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Data Load Error WRT_8114
From:   Dempsey, Mike

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019