PowerCenter
- PowerCenter 10.5
- All Products
Joiner Transformation Type
| Index Cache
| Data Cache
|
---|---|---|
Unsorted Input | Stores all master rows in the join condition with unique index keys. | Stores all master rows. |
Sorted Input with Different Sources | Stores 100 master rows in the join condition with unique index keys. | 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. |
Sorted Input with the Same Source | 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. | 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. |