"OR" in a join

jherr22 · Post by **jherr22** » Mon Jul 27, 2009 1:59 pm

Is there a way to incorporate an "OR" condition within a JOIN stage (or lookup)?

ddevdutt · Post by **ddevdutt** » Mon Jul 27, 2009 3:42 pm

Can you please explain a bit more elaborately as to what your requirement is?

ray.wurlod · Post by **ray.wurlod** » Mon Jul 27, 2009 5:02 pm

Even so, the answer is no in a Join stage. In a Lookup stage you have the possibility of a range lookup but that's a highly specific case of "OR". As noted, please be more specific.

jherr22 · Post by **jherr22** » Tue Jul 28, 2009 6:53 am

I would like to replicate the following:

select x.a, y.b
from x, y
where x.m = y.m
or x.n = y.n

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jul 28, 2009 6:57 am

What is the source ?

What is the data volume ?

ddevdutt · Post by **ddevdutt** » Tue Jul 28, 2009 10:28 am

Okay.

One of the ways you can achieve this is to do a lookup first (this will depend on your data volumes)
Then send the rejects from the first lookup to a second lookup stage where you use the same reference dataset.
You can then Funnel the outputs from both the lookup and proceed with any other transformations that you may have.

The first lookup will cater to your first constraint and the second lookup will cater to the second constraint in your "OR" statement.

Let me know if this works.

jherr22 wrote:I would like to replicate the following:

select x.a, y.b
from x, y
where x.m = y.m
or x.n = y.n

jherr22 · Post by **jherr22** » Tue Jul 28, 2009 12:48 pm

ddevdutt:

Perfect - that's the ticket!
I appreciate your help!

ddevdutt · Post by **ddevdutt** » Tue Jul 28, 2009 1:37 pm

Glad to be of help :D

DSXchange

"OR" in a join

"OR" in a join

Re: "OR" in a join