Null Handling in transformer

ag_ram · 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 · 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 · 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?

ag_ram · 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 · 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 · Post by **balajisr** » Tue Aug 07, 2007 3:37 am

Can you post your complete fatal message from the log if any?