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.