Joiner Transformation Cache

What are the caches available in Joiner transformation?
What is stored in Joiner cache(data cache) and Index cache?

Questions by amritabc

Showing Answers 1 - 0 of 0 Answers

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.

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

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.


  Was this answer useful?  Yes

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.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions