DSXchange

Whenever you extract that field from the database use any null handling function like COALESCE function because it may happen that database null does not match with data stage null

You can generate surrogate key from a surrogate key generator stage and also from transformer fro DB sequence.And give the proper database related info there.

I guess you defined the field in the transformer output as a not nullable field.So the records with null values are getting dropped.So in this case if you want null value just declare it as nullable. Or if you want it as not nullable then you can handle the null with null to empty or null to value f...