Multiple choice technology databases

Which of the following transformation has override option in properties?

  1. Lookup, Joiner

  2. Lookup, SQ

  3. SQ, Joiner

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Lookup transformation has an override option that allows you to override the default SQL query used for the lookup. Source Qualifier (SQ) also has a SQL override option to modify the source query. Joiner does not have an SQL override option because it joins data from different pipelines rather than querying a single source.

Keep practicing — related questions