Reject Records in Join
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
Reject Records in Join
Hi All,
How can we trap the reject records in Join.
Thanks in advance.
How can we trap the reject records in Join.
Thanks in advance.
-
- Participant
- Posts: 21
- Joined: Thu Oct 04, 2007 4:34 am
- Location: India
- Contact:
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
You requirement is to trap reject records using a JOIN stage? What kind of a join are you doing?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Does the requirement ask you to *use* a join stage?
State your requirement clearly, that would help others help you :D
State your requirement clearly, that would help others help you :D
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Premium Member
- Posts: 497
- Joined: Sun Dec 17, 2006 11:52 pm
- Location: Kolkata
- Contact:
-
- Participant
- Posts: 467
- Joined: Tue Mar 20, 2007 6:36 am
- Location: Chennai
- Contact:
Do you want records which don't have a match in the join in the rejected records?
If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the join, also you should change the nullable property to YES) from the right link. If the not nullable column is null you can send it to a file (this would be your reject link)
If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the join, also you should change the nullable property to YES) from the right link. If the not nullable column is null you can send it to a file (this would be your reject link)
Minhajuddin
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
<a href="http://feeds.feedburner.com/~r/MyExperi ... ~6/2"><img src="http://feeds.feedburner.com/MyExperienc ... lrow.3.gif" alt="My experiences with this DLROW" border="0"></a>
-
- Participant
- Posts: 80
- Joined: Sat Mar 18, 2006 10:27 pm
Try to use full outer and find the key column which is null on the reference to filter out after the joinMinhajuddin wrote:Do you want records which don't have a match in the join in the rejected records?
If so, you can use a left outer join(by properly ordering the links) and in a downstream transformer you can check if a not nullable column(you should pass a not nullable column to the output from the right link in the join, also you should change the nullable property to YES) from the right link. If the not nullable column is null you can send it to a file (this would be your reject link)
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia