Multiple choice technology packaged enterprise solutions

Which transformation is used for joining two or more sources.

  1. Setop

  2. Union

  3. Joiner

  4. Sorter
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The Joiner transformation in OWB (and similar ETL tools) is specifically designed to combine data from two or more input sources based on specified join conditions, similar to SQL JOIN operations. It can handle inner joins, outer joins, and complex join logic. The Setop transformation performs set operations (union, intersect, minus) on single or multiple sources, Union is for combining result sets (typically from similar sources), and Sorter is for ordering data.

AI explanation

The Joiner transformation in Informatica PowerCenter is specifically built to combine data from two or more heterogeneous or homogeneous sources based on matching join conditions, similar to a SQL join. Union/Setop transformations instead stack rows from multiple sources with the same structure (without matching keys), and Sorter simply orders rows from a single pipeline.

Keep practicing — related questions