Thanks for the example. In order to get rejected records into a DB table for Oracle, you would need to build in the logic to do the validation into your task. You would create a second target for rejected records, and apply a condition to c…"
Are you trying to grab the unpaired records from the join? If so, you can modify your join to output any combination of paired/unpaired records (in the join keys dialog, bottom right corner); then, you can add a target file for the "rejected"…"
Woodcliff Lake, NJ
Your Title or Position
Senior Manager, Strategic Accounts
Tell us about yourself, are you a ...