which is true about following
-
a. source qualifier joins the heterogeneous sources
-
b. joiner transformations joins the heterogeneous sources
-
c.joiner transformation can only join homogeneous sources.
-
d. source qualifier can joins both heterogeneous and homogeneous sources
The claimed answer is correct. Joiner transformation is specifically designed to join heterogeneous sources (data from different database types, flat files, or different connections) in the mapping pipeline after data has been extracted. Source Qualifier joins can only operate within a single homogeneous source (same database connection) because they push down SQL to the source. A Source Qualifier cannot join data from different source types, while the Joiner transformation operates in memory after data is extracted from heterogeneous sources.