Saturday, February 9, 2013

How to Calculate Memory Cache for Informatica Objects

Cache Calculator Is To Calculate Memory Per Informatica Object.

In Informatica Workflow we have something called Cache Calculator. This is to calculate the Data cache per objects .While working on objects like Lookup Cache, Joiner Cache, Aggregator Cache, Sorter Cache we don’t have worry about the complex memory size used by these objects if we can calculate it by ourselves.
This feature is available with version Informatica 8.1.1 onwards.


Now we will see how to do!
  • First you need to Login to the Workflow manager and Open the required session.
  • Once you have opened the session, there you can see mapping tab.
  • In the mapping tab you can find the transformation objects used in the Informatica Mapping.
  • Select one of the objects that would use memory for caching.
  • There you can find the Objects Data Cache Size and Objects Index Cache Size Properties.
The data cache Calculators are different for different objects
Lookups
As you can see below for Lookup transformation there is a calculate button which will calculate the memory size. In order to calculate the lookup cache size we need to give the number of unique rows in a lookup. To calculate the unique rows you can make use of the SQL override or the Session log data

Aggregator
In case of Aggregator transformation as seen below we can calculate the memory size but first we need to determine the number of groups in an aggregator transformation. For that you can use session log data or SQL query

Sorter
For Sorter transformation we need to give the number of rows in sorter

Ranker
For ranker Transformation we need to determine the number of rows in a rank using the session log or SQL

1 comment:

  1. This post is really nice..
    http://www.informaticaonlinetraining.co/

    ReplyDelete

Thank you :
- kareem