Page 1 of 1
Null Handling in transformer
Posted: Tue Aug 07, 2007 1:20 am
by ag_ram
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 ?
Posted: Tue Aug 07, 2007 1:27 am
by ArndW
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.
Posted: Tue Aug 07, 2007 1:47 am
by ray.wurlod
What specific null handling are you doing? Is there any field where you may have missed handling nulls?
Posted: Tue Aug 07, 2007 2:49 am
by ag_ram
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
Posted: Tue Aug 07, 2007 3:10 am
by ArndW
Keep on reducing the columns until you have one that is causing the abort, then post that.
Posted: Tue Aug 07, 2007 3:37 am
by balajisr
Can you post your complete fatal message from the log if any?