Multiple choice technology

SQL override in Source qualifier can be used

  1. a. to filter data during extraction

  2. b. to join two tables of heterogeneous source

  3. c. to configure

  4. d. none of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SQL override in Source Qualifier allows you to customize the default SQL query generated by Informatica, commonly by adding WHERE clauses to filter rows at extraction time. This improves performance by reducing data transfer. You cannot join heterogeneous sources with Source Qualifier SQL override - each Source Qualifier connects to one source type.