Use the cache calculator for aggregator, joiner, rank, and sorter transformations to improve performance.
Select to calculate the total requirements for a transformation based on inputs. The cache calculator requires different inputs for each transformation. You must select the applicable cache type to apply the calculated cache size. For example, to apply the calculated cache size for the data cache and not the index cache, select only the Data Cache Size option.
The cache calculator estimates the cache size required for optimal session performance based on your input. After you configure the cache size and run the session, you can review the transformation statistics in the session log to tune the configured cache size.
Note: You cannot use the cache calculator to estimate the cache size for an XML target.
Subscribe to:
Post Comments (Atom)
2 comments:
nice article post..
http://www.informaticaonlinetraining.co/
The blog is very interesting and will be much useful for us. thank you for sharing the blog with us. please keep on updating.
Informatica Training in Chennai
Post a Comment