How to capture unmatched records from "Join" Stage. This stage does not provide reject handling for unmatched records (such as in Inner Join)
Solution:
Use Outer Join operation. All rows on an outer link are output regardless of match on key values.How to:
Add Outer join operation for "Join’ stageWhen a match does not occur, Join stage inserts NULL values into unmatched columns
Filter stage can be used to test NULL values in unmatched columns
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://datagenx.slack.com/messages/datascience/
No comments:
Post a Comment