Lookup Stage

venkatvelpula · Post by **venkatvelpula** » Thu Oct 27, 2011 11:10 am

As we know lookup stage can handle multiple reference files in one stage.

I need to confirm the following,

- Same table with different source columns and with the same reference columns matching, Can I use one lookup stage to populate different output fileds using the one key field from the reference?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 27, 2011 12:51 pm

venkatvelpula · Post by **venkatvelpula** » Thu Oct 27, 2011 3:00 pm

That means, I have to use copy stage to expose that one reference file into mutiple files and then able to pull the required fields to the output. Right?

Also, How does it work with AND condition and OR condition? Like, we have in server,
If I have mutiple reference links on one lookupstage, I have to determine what's found and what's not found..and then use logical operators to determine which one should go to output.

jwiles · Post by **jwiles** » Thu Oct 27, 2011 9:40 pm

Yes...copy stage or transformer.

You can:
a) Perform all of the lookups in one stage (or separate stages) then use a transformer afterwards to choose between the three results.
b) Perform each lookup individually, passing rejects to the next lookup and funnel the results back together at the end

There is no OR construct in a parallel lookup stage.

Regards,