I am getting issue in one of my job,when i tried to run the job the some of the records are getting dropped from transformer stage before target stage.
message i am getting in log is:
Transformer_143,0: Field 'XXX' from input dataset '0' is NULL. Record dropped.
This message still getting even though handled nulls.
Check your source meta data in transformer for this field. If the field is defined as Nullable no and a null comes in then datastage will drop the record.
I've gotten this error before when I was certain that I'd dealt with nullability in all occurrences of the column in the transform stage... then I discovered that I'd used the column in a constraint. Perhaps you might have the same problem.
If your are not using that column in a constraint or in a stage variable and you are certain that each use in a derivation is handled as you have described then you have discovered a bug.
That derivation is why you are getting dropped records. You need to handle nulls in that derivation as well as in the one you posted earlier. You need to add a IF IsNull... to that clause.