DSXchange

I would prefer using a having clause in oracle.

If your data is huge in the reference table then lookup is not the right option.

You can always do a trail and run with your design but try to follow the approach with avoids the bottleneck on the server.

Use an aggregate stage after a lookup and get the count out of it. You can use filter or transformer stage to pick only records where count = 1.