Page 1 of 1
How to calculate the optimal size of all the lookup data set
Posted: Wed Jul 26, 2006 8:40 am
by venkat_nk
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
Posted: Wed Jul 26, 2006 4:17 pm
by ray.wurlod
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).