How to calculate the optimal size of all the lookup data set

venkat_nk · Post by **venkat_nk** » Wed Jul 26, 2006 8:40 am

used at the same time?
Based on
1. Number of CPU
2. CPU GHz,
3. Scratch size
4 Number of nodes and
5. RAM GB

Thanks,
Venkat

ray.wurlod · Post by **ray.wurlod** » Wed Jul 26, 2006 4:17 pm

Based, much more importantly, on the volume of data you propose to load into the reference Data Sets, and whether you propose to use virtual Data Set or Lookup File Set for your reference source.

The optimal size is one with the capacity to store that total volume.

You can not succeed without all the rows and columns you need in the lookups. The trick is to make sure that that's all you have.

Then you need to make sure that you have sufficient resources to cope with that volume, not the reverse (which is where you seem to be coming from).