Multiple choice technology databases

What is generally the most efficient way to join to join two tables in the same database?

  1. In the database

  2. using a source qualifier transformation

  3. using a joiner transformation

  4. his cannot be done in Power Center 8.x
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When joining two tables from the same database in PowerCenter, using a Source Qualifier transformation is most efficient because it pushes the join to the database level. The database optimized the join using its query engine. Joiner transformation joins data in memory after both tables are read, which is less efficient. The option 'In the database' is vague and not a PowerCenter component.

Keep practicing — related questions