Multiple choice technology

Which of the following about the data and index caches of a lookup transformation are true?

  1. Index cache stores data for the connected output ports and unconnected return ports

  2. Data cache stores data for the connected output ports and not for unconnected return ports

  3. Index cache stores data for the columns used in the lookup condition.

  4. Data cache stores data for the columns used in the lookup condition
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Informatica lookup transformations, the index cache stores data for columns used in the lookup condition to optimize performance. The data cache stores data for the connected output ports. This separation allows faster lookup operations by indexing the condition columns.

Keep practicing — related questions