How can I get records rejected at reference link....
I can get the records from source but is there any way to get reject at reference link in Lookup stage?
Thanks
SD
Get records rejected from reference link
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 103
- Joined: Fri Jan 18, 2008 12:55 am
- Location: chennai
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
A reject link sourced from a lookup stream will facilitate propagation of rejected rows through that link. You can use this link to work of rejected rows.
If you are looking for rejects from reference, then you need to look into full outer join or merge stage - based on your requirement.
Maybe you can clarify your requirement.
If you are looking for rejects from reference, then you need to look into full outer join or merge stage - based on your requirement.
Maybe you can clarify your requirement.
What exactly would you expect to see? If a stream row does not find a match in the reference lookup - what would you reject from the reference lookup? The only thing that can be sent down the reference link is the stream data - that, at least, is known.
Flip them and all you have is a bunch of rejects that do not have a match in the stream data (ref) table and, last time I checked, that can be a valid situation, but it may actually be what you want.
Everything from the reference or join etc... that did not match will be null (nothing there to match!).
Maybe I am missing the boat here??
Flip them and all you have is a bunch of rejects that do not have a match in the stream data (ref) table and, last time I checked, that can be a valid situation, but it may actually be what you want.
Everything from the reference or join etc... that did not match will be null (nothing there to match!).
Maybe I am missing the boat here??
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com