Re-Using Lookup stage

Madhav_M · Post by **Madhav_M** » Wed Oct 12, 2005 7:11 am

Hi,
I'm exploring, is there is anyway to reuse the lookup stages?
I mean,
In the input stream to lookup stage has 2sets(4) of columns
I want to perform lookup based on each sets and output the matched
rows.

Can it be done in datastage? I am told it is possible in Informatica.
can anyone throw some lights on this.

Thanks
Madhav.

track_star · Post by **track_star** » Wed Oct 12, 2005 9:26 am

Can you verify which input you're referring to (source file or lookup file)? You can create a lookup fileset if you want to reuse the lookup data, but I don't know if that's what you're trying to do.....

ray.wurlod · Post by **ray.wurlod** » Wed Oct 12, 2005 2:51 pm

The Lookup stage supports one or more reference inputs. More than one of these can read from the same source (virtual Data Set). The only exception is a sparse lookup, in which case the Lookup stage can have only one reference input link. However, you can have more than one Lookup stage in a job.

vmcburney · Post by **vmcburney** » Wed Oct 12, 2005 7:41 pm

Had trouble understanding your question. Are you talking about lookup up the same table twice in the one lookup stage? Consider using a source stage leading to a copy stage with two outputs leading to the lookup stage. The source is read just once but passed into the lookup stage twice.