Multiple choice technology

which of the below options are true during deletion of lookup ports in lookup transformation

  1. will improve performance in case of relation tables

  2. Will fail the session in relational lookup source

  3. will fail the session in flatfile lookup source

  4. None Of the above
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

In Informatica lookup transformations, deleting unused lookup ports improves performance for relational sources by reducing data retrieval. For flat file lookup sources, the session fails if you delete ports because flat file lookups require all ports to match the source definition exactly. Option B is incorrect because relational lookups do not fail when ports are deleted.

Keep practicing — related questions