datatype mismatch warnings

[prasannak]

We have a oracle source number field coming in with number(19,4).
In the target, the same has been defined as number(21,6)

And there are a lot of number fields like this in our tables.
Our ETL job expects a volume of 1 million rows everyday to be loaded from the source to the target.

Now, I know that datastage throws these warnings if the datatype mismatch occurs, but still lets it flow through since it does not affect the output as the target is of a higher scale and precision.
Is there anyway to suppress these warnings without having to:
1) Make any project level settings
2) Without having to increase the warning limit through dsjob command.

Since it is a question of processing 1 million rows, I am not sure if the job will get aborted when it reaches a warning limit (i think by default, job aborts after 50 warnings are logged in datastage).

Any ideas would be much appreciated.

[ray.wurlod]

Change your job design to implement a DecimalToDecimal() conversion and make the metadata in your job design match what's in the tables.

[prasannak]

Thanks ..Will try this out..
Is it similar to the cast function we have in oracle ?

Btw, I like the signature you have there