Job failing with warnings

ketanshah123 · Post by **ketanshah123** » Mon Mar 22, 2010 1:30 am

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]

keshav0307 · Post by **keshav0307** » Mon Mar 22, 2010 1:41 am

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

ketanshah123 · Post by **ketanshah123** » Mon Mar 22, 2010 2:00 am

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 ...

rohithmuthyala · Post by **rohithmuthyala** » Mon Mar 22, 2010 2:39 am

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.