Multiple choice technology databases

SQL override option is present in which transformation?

  1. Filter

  2. Router

  3. Lookup

  4. Expression
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Lookup transformation provides the SQL Override option, allowing you to customize the default query generated by Informatica. With SQL Override, you can add filters, modify the SELECT statement, or change the lookup condition SQL. This is useful for performance tuning or implementing complex lookup logic. Filter and Router use filter conditions (not SQL), and Expression uses expression logic - none have SQL Override capability.

Keep practicing — related questions