Lookup file Set

kksr · Post by **kksr** » Wed Jan 04, 2006 4:11 am

Hi All,

one of my Job with Lookup having Reference Link Seqential file Stage
this is possible? if possible then what is the use of Lookup File Set Stage?

help me....

KKSR

balajisr · Post by **balajisr** » Wed Jan 04, 2006 4:27 am

Hi

Lookup with lookup fileset will be faster.

--Balaji S.R

kumar_s · Post by **kumar_s** » Wed Jan 04, 2006 5:10 am

Hi,
Lookup file set stage is similar to hash in Server jobs.
It groups all the date in the lookup table and load in to the the file set, So that it will be faster at the time of lookup.

-Kumar

ray.wurlod · Post by **ray.wurlod** » Wed Jan 04, 2006 3:38 pm

A Lookup File Set includes an internal index on the key columns.

A Sequential File stage would need to be completely imported into a virtual Data Set, but this lacks an index, so that lookups would still require a partial or full scan.