Hi
My parallel jobs does some Gud ETL Functionality. :D
The only problem is that some of Column's values are getting truncated in some stages (Like Varchar2(40) to Varchar2(30)) and in some later stages getting transformed back to the original length.(like Varchar2(30 to Varchar2(40))
So finally when i get the data the column value shows some truncation.
I can go through each and every stage to find out the root cause.
But that is very cumbersome since there are around 20 stages and 15 such jobs which are showing similar problems.
Is there any environment variable which, when set will log all such truncations that happen.I went through the list but couldn't find the exact match...
Any help...
Thanks in Advance,
Venky
Env Variables for Default Conversion
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Fri Nov 04, 2005 8:34 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: