Which is beeter ? Lookup File set or Dataset or Fileset

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
prematram
Participant
Posts: 14
Joined: Fri Dec 14, 2007 2:01 am
Location: Chennai

Which is beeter ? Lookup File set or Dataset or Fileset

Post by prematram »

Hi,
Which file is better.....Lookup File set or Dataset or Fileset and when these each one is getting used to get efficient result ...??
Prem R.
aakashahuja
Premium Member
Premium Member
Posts: 210
Joined: Wed Feb 16, 2005 7:17 am

Post by aakashahuja »

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
L'arrêt essayant d'être parfait… évoluons.
Post Reply