Record Dropped

baglasumit21 · Post by **baglasumit21** » Tue Sep 13, 2011 6:46 am

suse_dk wrote:You write you are performing your null handling in a stage variable - so do you make sure to either use the result in a constraint on the output link or as input to your derivation?

Hi Susanne,

Will that have any impact if the derivation is used in stage variable, but variable is not used in output link derivation or constraint?

Rgds,
Sumit

suse_dk · Post by **suse_dk** » Tue Sep 13, 2011 6:54 am

yes - in that case you'll still be sending records with null values out the link, which causes the runtime error you are describing.

So, map the stage variable to your derivation for cocpysno...

arunkumarmm · Post by **arunkumarmm** » Tue Sep 13, 2011 8:04 am

The column which you are checking for NULL is from any lookup or join? If so, have you defined $APT_STRING_PADCHAR?

kommven · Post by **kommven** » Tue Sep 13, 2011 9:39 am

What is Metdata for this column in source and target as defined in that transformer.
Make sure that the Source metadata is nullable.

DSXchange

Record Dropped

Re: Record Dropped