If i have a job like database --> transform --> database, instead of doing a NullToValue() on almost every column in the transform, is there a way to do this at the job level so that every null value in any column will be converted to a non-null value of my choice?
Thanks
Using NullToValue() at a job level
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
No, but you can multi-select the column derivations then choose Derivation Substitution from the right-click menu. By this means you can change as many derivation expressions as you wish at one time.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.