Dropping records in a PX transformer

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
vjreddy65
Participant
Posts: 7
Joined: Tue Apr 06, 2004 7:34 pm

Dropping records in a PX transformer

Post by vjreddy65 »

Iam doing a left outer join and have a transformer following that. I have some Null handling, other checks and derivations in the Transformer but no constraints. It appears that the Transformer is dropping certain records where I have not matching records from the right link (These values should be null in a left outer join). Any tips would be highly appreciated.

-vj
asadi
Participant
Posts: 10
Joined: Sun Nov 02, 2003 9:18 pm

Post by asadi »

If you attempt to evaluate nulls within a transformer PX will drop those rows automatically. Before running any functions or evaluations on a suspect null value check for nulls before you process.
Post Reply