how to calculate the optimum cache size in aggregator
transformation?



how to calculate the optimum cache size in aggregator transformation?..

Answer / sarvesh

in aggregator
data cache size is:
no.of groups(sigma(colomnsize)+7)and same for index
cache also

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Informatica Interview Questions

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,


I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.

3 Answers   Amdocs,


Useful UNIX commands regular/frequently used

1 Answers   Deloitte,


What is DTM process?

4 Answers  


What is event and what are the tasks related to it?

0 Answers  






What is data merging,data cleansing,sampling?

4 Answers  


Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


Can you copy the session to a different folder or repository?

1 Answers  


Do joiner transformation use cache? If so describe?

2 Answers   Patni,


What are the Advantages of de normalized data?

3 Answers  


Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

3 Answers   Infosys,


If I have a index defined on target table and if set it to bulk load will it work ?

4 Answers   IBM,


Categories