Multiple choice technology packaged enterprise solutions

Which transformation is used for unioning inputs from multiple transformation

  1. Union

  2. Splitter

  3. Setop

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

In Oracle Warehouse Builder (OWB), the Setop (Set Operation) transformation merges input streams from multiple sources using set operators such as UNION, UNION ALL, INTERSECT, or MINUS. Joiner combines data horizontally based on keys, Splitter separates streams, and the generic Union is not OWB's set-based transformation.

Keep practicing — related questions