DSXchange

Hi We have a job that fetches data from oracle 10g and populates into Sql server. Job Design : Oracle Enterprise -> Transformer -> ODBC Enterprise Issue Detail : The oracle table has a few columns that have been defined as NUMBER. These fields are being mapped to a Decimal(33,15) field in Sql Server...

A NULL value was being encountered for a partitioning column, hence the job was failing. There was a slight confusion about the error as the director was showing an error for the Transformer stage.

Thanks for all your help.

The DB2 database is partitioned in our case.

Could you please let me know, what column are you talking about? The error does not mention ant column name / number.

Hi One of my DataStage parallel jobs is getting aborted and the director shows the following error messages. tfpCustIp,0: DB2 get row partitioning data Error. tfpCustIp,0: SQLCODE = -6039; SQLSTATE= tfpCustIp,0: SQL6039N Partitioning column "0" is currently defined as not nullable. tfpCust...