Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - How to calculate the optimum cache size in aggregator transformation?




494
views
asked marvit September 20, 2014 08:00 AM  

How to calculate the optimum cache size in aggregator transformation?


           

1 Answers



 
answered By vishnoiprem   0  
If you using Informatica Version 8.x, you can set **Auto Cache** option at session properties. If you are using lower version then follow this forumlae:
Aggregator:
Index Cache size = (Sum of column sizes in group by ports + 17) * number of groups
Data Cache Size = (Sum of column sizes of output ports + 7) * number of groups
number of groups will be 24 months * 500 Customers = 12000
Compute Column width and substitute in the above formulae.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert