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.
datatype mismatch warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: