Hi Folks
I have a Transformer stage , and input fields to the transformer is a Nullable Source. All transformations and Null handling is done in the transformer , still i end up getting a FATAL message saying source and target have differing Nullability
What is the possible cause ?
Null Handling in transformer
Moderators: chulett, rschirm, roy
If the input column in a transforms stage is nullable and the output is not and you handle nulls appropriately you will not get this message. Can you make a copy of the job and remove portions until the error goes away - that way you can narrow down the possible cause.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Keep on reducing the columns until you have one that is causing the abort, then post that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>