Multiple choice technology

________ is used to join two related heterogeneous sources residing in different locations or file systems

  1. Source Qualifier Tranformation

  2. Joiner Transformation

  3. Lookup Transformation

  4. Stored Procedure Transformation

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Joiner Transformation is specifically designed to join data from heterogeneous sources residing in different locations or file systems. Source Qualifier reads source data, Lookup looks up values from a flat file or relational table, and Stored Procedure executes database procedures - none are designed for joining heterogeneous sources across locations.