Load unmatched data
Moderators: chulett, rschirm, roy
Load unmatched data
Hi,
I want to get Unmtched data to be load in Target Table. I am comparing source record with the Target Table.
How can I do this with Merge Stage ?
Thanks
I want to get Unmtched data to be load in Target Table. I am comparing source record with the Target Table.
How can I do this with Merge Stage ?
Thanks
Refer to Ray's first reply in this post.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks DSguru2B,
I read that Post but It didnt help me.
Here is the detail what I am doing:
I am gettig recored from flat file and I am looking this record to the Target table and If Data matches then I want to reject and If not matching then I am inserting this recored to Target Table.
I tried Lookup but its not loading unmatched data to table, might be I am doing wrong.
Plesase help me
Thanks
I read that Post but It didnt help me.
Here is the detail what I am doing:
I am gettig recored from flat file and I am looking this record to the Target table and If Data matches then I want to reject and If not matching then I am inserting this recored to Target Table.
I tried Lookup but its not loading unmatched data to table, might be I am doing wrong.
Plesase help me
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can use a lookup stage, specify a reject link to capture the unmatched inputs and set your Lookup Failed rule accordingly.
You could also use a right outer join; the rows with NULL from the left inputs are unmatched rows in the target.
You could also use a right outer join; the rows with NULL from the left inputs are unmatched rows in the target.
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.
Re: Load unmatched data
In Lookup stage There is one property If Not Found = Output you can retrive all your unmatched data in the reject link and passed it to the Target Table
Thanks
Ashish Arora[/img]
Thanks
Ashish Arora[/img]
Re: Load unmatched data
You asked for it to be done in Merge stage, you got expert advice on so many stages that can get your work done.swades wrote:How can I do this with Merge Stage ?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.