Hi,
I am new to datastage parallel, please let me know how to achive not(notfound(....)) results in parallel edition.
my requirement is i need to pass only new records which is not present in target.
Thanks in Advance
-Vijay
How to achieve not(notfound()) results in parallel
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Lookup stage has a "lookup failed" rule - you program it as you require. If you want to continue processing the stream input row where lookup failed, you set the rule to "Continue" and test a lookup key column for being null. The change detection stage types allow you to set a code value for the situation you describe; that the key exists in the "before" or "first" data set but not in the "after" or "second" data set.
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.