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.