Page 2 of 2
Re: Record Dropped
Posted: Tue Sep 13, 2011 6:46 am
by baglasumit21
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
Posted: Tue Sep 13, 2011 6:54 am
by suse_dk
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...
Posted: Tue Sep 13, 2011 8:04 am
by arunkumarmm
The column which you are checking for NULL is from any lookup or join? If so, have you defined $APT_STRING_PADCHAR?
Posted: Tue Sep 13, 2011 9:39 am
by kommven
What is Metdata for this column in source and target as defined in that transformer.
Make sure that the Source metadata is nullable.