Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
ag_ram
Premium Member
Posts: 524 Joined: Wed Feb 28, 2007 3:51 am
Post
by ag_ram » Tue Aug 07, 2007 1:20 am
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 ?
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Aug 07, 2007 1:27 am
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.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Tue Aug 07, 2007 1:47 am
What specific null handling are you doing? Is there any field where you may have missed handling nulls?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
ag_ram
Premium Member
Posts: 524 Joined: Wed Feb 28, 2007 3:51 am
Post
by ag_ram » Tue Aug 07, 2007 2:49 am
Hi Ray
I have used the following
a) Used NullToValue
b)Used If/Else and ISNULL
c)NullToEmpty
3 Nullables (2 Varchars , 1 Date) . As for the date for null values a Non Nullable input date is assigned.
Arnd
I tried to break the job , fails again at the same transformer
ArndW
Participant
Posts: 16318 Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Post
by ArndW » Tue Aug 07, 2007 3:10 am
Keep on reducing the columns until you have one that is causing the abort, then post that.
balajisr
Charter Member
Posts: 785 Joined: Thu Jul 28, 2005 8:58 am
Post
by balajisr » Tue Aug 07, 2007 3:37 am
Can you post your complete fatal message from the log if any?