DSXchange

Hello,

I am fetching my data from Oracle database,using ODBC connections.After processing ,I am trying to load it back again to the Oracle database using a different ODBC connection in a different table ,of the same user.

While loading I get the following error:

APT_CombinedOperatorController,0: [Oracle][ODBC] Numeric value out of range.

I checked the schema in the source and target table .It was fine.I also tried creating a new table in database with exactly the same schema and then tried to load the data,but still I got the same error.

Please suggest a solution to this problem.

Thanks in advance

Regards
Hari

The solution is to change the datatype to accept the bigger value or change the value to fit into the datatype.

Put a reject link in your output stage and point it at a peek stage. Run the job and examine the data in error to determine which column is causing you grief.