DSXchange

HI

My job is like

oracle enterprise stage ----->Transformer------->ODBC stage.

Source database is Oracle
Destination database is SQL server.

My jobs are getting aborted with following warning message :
(mentioning just one for eg. there are 50 such column gvng same error)

Oracle_Enterprise_5: When checking operator: When binding output interface field "FISCAL_MONTH_KEY" to field "FISCAL_MONTH_KEY": Implicit conversion from source type "decimal[28,0]" to result type "int32": Possible range limitation. [api/interface_rep.C:6243]

In the source table the column type is decimal[28,0],
whereas in the OEE stage, the coulmn is defined as Integer.

keshav0307 wrote:In the source table the column type is decimal[28,0],
whereas in the OEE stage, the coulmn is defined as Integer.

in source oracle table data type is number in datastage in destination we are ref. it as integer ...

Read the column in the source table as "decimal[28,0]" and convert the column's datatype in the transformer stage to the datatype of the target table.