DataSet/LookUpFileSet

[Althaf6553]

Hi

We have jobs ,Where we need to LookUp on either DataSets or LookUpFileSets.And data to be processed is more than 40 lakhs
Which would be better Data Sets or Look Up FileSets.PLease suggest and why?

[ray.wurlod]

There's nothing in QualityStage that requires the use of these. But you have posted in the QualityStage forum.

I accept that DataStage and QualityStage shared the same Designer in version 8, but QualityStage does not perform lookups using the stage types you have nominated.

[lvraji]

Hi

We have jobs ,Where we need to LookUp on either DataSets or LookUpFileSets.And data to be processed is more than 40 lakhs
Which would be better Data Sets or Look Up FileSets.PLease suggest and why?

Hi,

As Per My knowledge cosider U can go use LookupFile Set. Because u mention data as 40 lacks data if you have that much data u can use LookupFile set. If you want use dataset that can give less performence.

Regards,
LV

[Minhajuddin]

Hi

We have jobs ,Where we need to LookUp on either DataSets or LookUpFileSets.And data to be processed is more than 40 lakhs
Which would be better Data Sets or Look Up FileSets.PLease suggest and why?

If I had to choose between Lookup fileset and a Dataset, the first thing I would see was the number of times this data is being used for reference. If it's being used in more than one place for lookups, I would go with the Lookup fileset, else I wouldn't bother creating Lookup filesets.

But, again using a lookup is altogether a different thing. If I had 4 Million records for input, I may have not gone with a lookup at all. But, it all depends on the resources available, the input data etc,.

[ray.wurlod]

I still fail to see the relevance to QualityStage or, for that matter, to U (one of our occasional posters).

The second person personal pronoun in English is spelled "you", not "u".

[Minhajuddin]

Ray, I think the OP has put the post in the wrong forum, It is supposed to be in Datastage Parallel forum.