Reference Links to Lookup Stage

lshort · Post by **lshort** » Wed Jun 01, 2005 1:20 pm

From Manual:
The Lookup stage can have a reference link, a single input link, a
single output link, and a single rejects link. Depending upon the type
and setting of the stage(s) providing the look up information, it can
have multiple reference links (where it is directly looking up a DB2
table or Oracle table, it can only have a single reference link).

>I dont understand the direct to DB2/Oracle reference made above. The designer appears to allow me to create a job that has more than one ref link from Oracle/DB2 to Lookup Stage. Did I miss something?

lshort · Post by **lshort** » Wed Jun 01, 2005 2:19 pm

Duh!
I found what I was missing.
Only one ref link is allowed when the LOOKUP_TYPE=Sparse

alanwms · Post by **alanwms** » Wed Jun 01, 2005 2:55 pm

Lance,

Remember that sparse lookup option puts records into the lookup dataset as it finds them in the (DB2 or Oracle) database. Subsequent lookups will retrieve from the dataset instead of having to make the call to the database. This works well when you reference a small number of different keys in your lookup.

Alan

lshort · Post by **lshort** » Wed Jun 01, 2005 3:09 pm

Thanks Alan, I'll be sure to keep that in mind.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 01, 2005 4:36 pm

Just do the other lookups using another Lookup stage.