plavania

 Profile Answers by plavania 

• Jun 19th, 2006

 

- Look-up file stage - Generally used with Look Up stage

- Hash Look-up

- you can also implement a "look up" using Merge stage

shiva

• Jun 29th, 2006

 

there are two types of lookupslookup stage and lookupfilesetLookup:Lookup refrence to another stage or Database to get the data from it and transforms to other database.LookupFileSet:It allows you to create a lookup file set or reference one for a lookup. The stage can have a single input link or a single output link. The output link must be a reference link. The stage can be configured to execute in parallel or sequential mode when used with an input link. When creating Lookup file sets, one file will be created for each partition. The individual files are referenced by a single descriptor file, which by convention has the suffix .fs.

sreenivas

• Jul 31st, 2006

 

hi,

I Have Datastage s/w from this I can work on some job's ...

and not on parallel job's............. if i want to work on this, I  need Enterprise Edition S/w or I can implement lookup stage in server job's........?

plz, I need help regarding this Info.

And If any one have lookup sample job plz post that job.

Thank U

Regards

sree

Bharath narahari

• Dec 5th, 2006

 

U can also use the sparse look up property when u have large data in the look up table .....