Lookup File set v/s dataset

mc_harsha · Post by **mc_harsha** » Mon Feb 25, 2008 3:35 am

Hi,

I am using Datasets for lookup purposes in jobs Instead of Lookup file set .

Is there any con's(disadvantages) if i use dataset as lookup?

with regards,
mch

ArndW · Post by **ArndW** » Mon Feb 25, 2008 3:40 am

Functionality is the same, performance might be a little slower. I don't like using lookup filesets because you cannot "view data" on them during the development phase. Once you have a functioning job you can convert datasets to lookup filesets so that you can take advantage of the prebuilt indices.

mc_harsha · Post by **mc_harsha** » Mon Feb 25, 2008 3:53 am

:D thanks for your answer....

ray.wurlod · Post by **ray.wurlod** » Mon Feb 25, 2008 4:15 am

To get a more technical answer, search DSXchange for LUT_CreateOp.