Posted: Thu Apr 06, 2006 2:47 pm
If POS is fixed (i.e only M/D/R) then you can use the below logic using Join stages.
1) Splitt the Input data into 3 datasets/Files, one for each POS
2)Do a full outer join to Join any two datasets.(take Dataset M and Dataset D)
3)Do the Null handling in a transformer.
4)Do a Full outer to join the Output from Transformer and remaing Input data set (dataset R) and do the required null handling.
1) Splitt the Input data into 3 datasets/Files, one for each POS
2)Do a full outer join to Join any two datasets.(take Dataset M and Dataset D)
3)Do the Null handling in a transformer.
4)Do a Full outer to join the Output from Transformer and remaing Input data set (dataset R) and do the required null handling.