All Forums Tools
janus 4 posts Joined 06/09
19 Jan 2010
TPT load from ORACLE to Teradata

Hi All,
I'm trying to use TPT to load data directly from an Oracle table to Teradata. BUT.. I'm having a little problem with numeric data types.
In oracle, I have a lot of different NUMBER(10,0) and other columns.
Lets take one for example a column called DURATION. The actual data in this column fits in an INTEGER type easily. So in the SCHEMA in the TPT script file and in Teradata, i identified it as INTEGER.
Now when running the TPT script, i get this error:

Error: Row 1: data from source column too large for target column
Column: DURATION, Data: '3'

And it is like this for every Numeric column. I even tried to put in everywhere the exactly the same data type, NUMBER(10,0) in Oracle, DECIMAL(10,0) in Teradata and the TPT SCHEME, but no luck.

The only way i see is to char everything and then in the later ETL stages to cast them back to whatever i need.

Any help would be great!

feinholz 1234 posts Joined 05/08
28 Jan 2010

DECIMAL(10,0) in the TPT schema should work.

If that does not work, please send me the output from the job, the job script and even the log file (the .out file, which is binary). I will take a look to see if I can figure out what is going on.


You must sign in to leave a comment.