✍ Kashif M

Sunday, 3 August 2014

Cache in Informatica

By on August 03, 2014

What do you mean by Index cache and Data cache ?Explain it ?

1)Informatica server create Index and Data cache for Aggregator, Rank, Joiner, Look up Transformations.

2)Informatica server stores key values in Index cache,   and output values in data cache.

3)Informatica server  create cache files based on Informatica Server Code Page.

4)If Informatica server require more memory, it stores overflow values in cache files. If session completes server      releases cache memory and deletes cache files.

Index Cache
Data Cache
Stores group values as configured in the Group-By ports.
Stores calculations based on the Group-By ports.
Stores group values as configured in the Group-By ports.
Stores ranking information based on the Group-By ports.
Stores index values for the master source table as configured in the join condition.
Stores master source rows.
Stores lookup condition information.
Stores lookup data that is not stored in the index cache.

Cache files located in which directory?
Informatica server locate index and data cache files in $PMCacheDir .
For index cache file it store with *.idx format and  for data cache file *.dat.

After successfully executing session Informatica server delete index and data cache files.

Cache in Informatica
Cache in Informatica
Explain Briefly about Session Caches?

Aggregator Cache, Rank Cache, Lookup Cache, Joiner Cache.

Aggregator Cache : 

When the Informatica Server runs a session with an Aggregator transformation, it stores data in memory until it completes the aggregation. When you partition a source that uses an Aggregator transformation, the Informatica Server creates one memory cache and one disk cache for each partition. It routes data from one partition to another based on group key values of the transformation

Rank Cache: 

When the Informatica Server runs a session with a Rank transformation, it compares an input row with rows in the data cache. If the input row out-ranks a stored row, the Informatica Server replaces the stored row with the input row.

Joiner Cache:

When the Informatica Server runs a session with a Joiner transformation, it reads all the rows from the master source and builds memory caches based on the master rows. After building these caches, the Informatica Server reads rows from the detail source and performs the joins.
The Informatica Server creates the index cache as it reads the master source into the data cache. The Informatica Server uses the index cache to test the join condition. When it finds a match, it retrieves row values from the data cache. 

To increase join performance, the Informatica Server aligns all data for joiner caches on an eight byte boundary.

Lookup Cache:

The Informatica Server builds a cache in memory when it processes the first row of data in a cached Lookup transformation. It allocates memory for the cache based on the amount you configure in the transformation or session properties. The Informatica Server stores condition values in the index cache and output values in the data cache. The Informatica Server queries the cache for each row that enters the transformation.

What is meant by Incremental Aggregation where it can be used?
Incremental Aggregation is used to improve session performance It is used only if source changes incrementally between sessions, and capture those incremental changes.

mkashu: Cache in Informatica
Review : Kashif | Kashif
Update: August 03, 2014 | Rating: 4.5

Comment for "Cache in Informatica "


  1. Wonderful answers. Really a very good website for reference. Keep up the good work. Thanks for such a clear explanation.



1z0-482 Dumps (2) 1Z0-525 Dumps (1) About Kashif (1) BI Apps Installation (1) BI Publisher (2) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) mkashu (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)