Multiple choice technology databases

To check a record which is present in the target table or not. Then which transformation is required?

  1. Joiner

  2. Lookup

  3. Source Qualifier

  4. All
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Lookup transformation is used to check if a record exists in the target table. It queries a cached version of the target table and returns matching rows based on the lookup condition. This is commonly used for incremental loading (checking for duplicates before insert) or slowly changing dimensions (determining if a row exists before update). Joiner combines two sources in the pipeline, and Source Qualifier operates at the source database level.

Keep practicing — related questions