DSXchange

Hi,
Which file is better.....Lookup File set or Dataset or Fileset and when these each one is getting used to get efficient result ...??

Depends what operation you want to perform.

Look up file set is a separate case altogether, while as per datasets and filesets, if you are gonna use them for storage (intermediate / final), then I believe that dataset is better.

Datasets are files in an internal format, something which PX understands and deals, hence the speed.

P.S:- Just having a particular stage will not guarantee speed and efficient usage of resources. many more things are to be considered.

Hope it helps.

Cheers
Aakash