Multiple choice technology

Integration Service creates which cache while running a session using the sorter transformation

  1. Index

  2. Data

  3. Index and Data

  4. Sorter
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

The Integration Service in Informatica creates a Sorter cache when running a session that includes the Sorter transformation. This is a specialized cache type specifically designed for sorting operations. It's different from Index or Data caches used by other transformations like Lookup, Aggregator, or Joiner. The Sorter cache stores rows temporarily while performing the sort operation based on the specified sort keys.

Keep practicing — related questions