Oracle datatype warning

[bala_135]

Hi,

I am using Oracle 10G.
One of the field in Oracle is of number(8).
When i import it through Plugin metadata definitions i am getting the datatype as decimal(8,0).
When i import it thro Orchestrate schema definitions its giving me int32 for that particular field.

When i use the Orchestrate schema for my job
i am getting the warning mentioned below.

Oracle_Enterprise_6: When checking operator: When binding output interface field "XXXXX" to field "XXXXX": Implicit conversion; from source type "decimal[38,10]" to result type "int32": Possible range/precision limitation.

How to avoid this warning.
Any inputs most appreciated.

Regards,
Bala.

[kumar_s]

You can find one of the recent post with the same issue. It is found that integer without precision is taken as decimal(38,10) as default. Try to edit the medata manully from DS manager and use it.