I'm looking for experienced Teradata and Datastage folks who are willing to take up a 9 month contract in sunny south Florida! Please contact stephenv@consultis.com if you have what it takes or know someone who does! Job Description:

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'