DSXchange

it can be done thro' transfer but given modify stage is lighter was using this

That's an alert, notifying you that a 255 character string may contain a number that is too large to load into a Decimal with precision less than 255.

You could try adding a NOWARN specification, but probably will end up adding a message handler to demote this particular alert to informational.

DataStage is trying to "do the right thing" by warning you.

Another (probably better) solution is to change the string to VarChar(38) (or whatever precision you've specified).

I have also observed this issue in datastage. Transformer is the only stage which doesn't give this warning in implicit or explicit conversion. Other all stages give this datatype conversion warning.

Actually another thing sort of off topic, why do you have a decimal without actually specifying any decimal places in the format? It should probably read something like [38,2] to allow for 2 decimal places?

Because of Oracle - blame Oracle bin Larry.

For example Integer maps into Oracle as NUMBER(38) which the rest of the world would understand as Decimal(38,0).