sreenu007

 Profile Answers by sreenu007 Questions by sreenu007

• Mar 24th, 2009

 

The Informatica server stores the conditional values in index cache or joiner cache and output values are stored in data cache.

sreenu007

 Profile Answers by sreenu007 Questions by sreenu007

• Mar 31st, 2009

 

Joiner Transformation cache are consists four types. there persisted cache,static cache,dynamic cache and sharing cache.

The Informatica server stores the conditional values in index cache or joiner cache and output values are stored in data cache.

sahan

 Profile Answers by sahan 

• Jul 16th, 2009

 

Integration service creates index and data cache in memory.

Integration service reads the data from master and detail sources and then creates the index on master source and data on detail source.

The integration service performs the join on the master source with data cache.

raam.pt

 Profile Answers by raam.pt 

• Aug 18th, 2009

 

Caches in JTR are 2.

1) Data Cache
2) Index Cache

1) Data Cache: It stores master source rows OS source table as configured in join condition.

2) Index Cache: It stores index values for master.

Rashmirekha

 Profile Answers by Rashmirekha 

• Sep 2nd, 2009

 

For Unsorted Input joiner transformation,
i)
Data cache stores all master rows in the join condition with unque index keys
ii)
Index cache stores all master rows.

For Sorted Input with
Different Sources,
i) Data cache stores 100 master rows in the join condition with unique index keys.
ii)
Index cache Stores master rows that correspond to the rows stored in the index cache. If the master data contains multiple rows with the same key, the Integration Service stores more than 100 rows in the data cache.

For Sorted Input with the Same Source,
i) Data cache Stores all master or detail rows in the join condition with unique keys. Stores detail rows if the Integration Service processes the detail pipeline faster than the master pipeline. Otherwise, stores master rows. The number of rows it stores depends on the processing rates of the master and detail pipelines. If one pipeline processes its rows faster than the other, the Integration Service caches all rows that have already been processed and keeps them cached until the other pipeline finishes processing its rows.
ii)
Index cache Stores data for the rows stored in the index cache. If the index cache stores keys for the master pipeline, the data cache stores the data for master pipeline. If the index cache stores keys for the detail pipeline, the data cache stores data for detail pipeline.