![Image](http://i167.photobucket.com/albums/u138/GatorNutz/px_job.jpg)
The initial run completed successfully, however the "change" test failed:
Code: Select all
APT_CombinedOperatorController(0),0: Field 'DVP' from input dataset '0' is NULL. Record dropped.
However, this field is purposed as 'Type 2' and is compared to the value in the lookup/target.
The field for the matching record is NULL in the lookup/database as well.
The only thing I can think of is that the SCD stage is having issues with NULL during the Type 2 compare.
Any thoughts on how to correct this? I've tried NullToEmpty() in the Transformer Stage before the SCD as well as within the Upsert Derivation.
![Image](http://i167.photobucket.com/albums/u138/GatorNutz/px_scd_stage.jpg)
Code: Select all