Multiple choice technology databases

Which transformation we will use if want to efficiently join two tables residing in same database?

  1. Joiner

  2. Source Qualifier

  3. Both of above

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

When joining two tables from the same database, using Source Qualifier with a custom SQL join is more efficient than Joiner transformation. This leverages the database's native join capabilities and avoids moving data between systems unnecessarily.

Keep practicing — related questions