Hi all. I'm new in Datastage development and I need to migrate data from a staging table to a final table on DB2. I need to only export data that conform to the business rules to the final table and all the rest sent to an error table. How can I achieve this, is Reject table appropriate for this and if yes how do I do it.
Thank you in advance.
Error handling
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Use a Transformer stage output link constraint to enforce your business rule. Good rows are pushed out that output link; all other rows (the rejects) can be pushed out a second output link by making the second output list a "rejects" link.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.