reject link in join stage

bhargav_dd · Post by **bhargav_dd** » Sun Jul 11, 2010 9:58 pm

can any one please how to implement reject link in join stage? i have data to be joined and if i get any rejects in the data i have to store it in reject link.

ray.wurlod · Post by **ray.wurlod** » Sun Jul 11, 2010 10:34 pm

There is no such thing as a reject from a join - just like in SQL you get the result of the join. Nothing more, nothing less.

stuartjvnorton · Post by **stuartjvnorton** » Sun Jul 11, 2010 10:57 pm

outer join -> filter (check for nulls on the other side, ie: non-join)
join -> good link
non-join -> reject link

ray.wurlod · Post by **ray.wurlod** » Mon Jul 12, 2010 12:28 am

Because join's don't have rejects, the Join stage does not support a reject link.

stuartjvnorton · Post by **stuartjvnorton** » Mon Jul 12, 2010 12:52 am

ray.wurlod wrote:Because join's don't have rejects, the Join stage does not support a reject link. ...

Trying to read between the lines: this would simulate what he appears to be looking for.
Work with me here Ray.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 12, 2010 1:56 am

Yes, but a Join stage is not the correct stage type. Either a Lookup stage or a Merge stage is needed to get a reject link. That's the point I'm making.