Look Up file set

PrasannaLkashmiBurri · Tue May 27, 2008 6:35 am

Hai,
How LookUp file set will be useful,what's the difference between lookup files and look up file sets.

thanks,
Prasanna.

ray.wurlod · Post by **ray.wurlod** » Tue May 27, 2008 6:51 am

What's a "lookup file"?

Althaf6553 · Post by **Althaf6553** » Mon Jun 09, 2008 10:38 pm

I think she meant to say this
"whats the difference
In looking upto a lookup file set and looking up to a normal file?"

Minhajuddin · Post by **Minhajuddin** » Tue Jun 10, 2008 2:18 pm

The only advantage you have with "Lookup Filesets" is that the lookup tables are created when you create the lookup filesets. But, when you do a lookup against a file,dataset or a database(Normal lookup) The lookup tables are created during the execution of the job.

So, Lookup filesets would save some time if you are using the same reference data in more than one place. I am sure this has been discussed many times in this forum, A search would give you more information.