Multiple choice technology

While using a lookup transformation , the columns which go to index cache are

  1. Columns specified in condition

  2. Columns specified other than the condition

  3. Primary key

  4. Foreign key
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica Lookup transformations, the columns used in the lookup condition are cached in the index cache for fast searching. Other columns go to the data cache. This optimization improves lookup performance by indexing on the join/condition columns.

Keep practicing — related questions