Given this picture of a PowerCenter Mapping and assuming there is no SQL override in the Source Qualifier:
Identify all of the true and correct statements listed below. Choose 2 answers
A. This picture depicts a join that will be processed within the Informatica PowerCenter engine
B. This picture depicts a join that will be processed in a database
C. This picture depicts a SQL UNION operation
D. This picture depicts an Informatica Homogeneous Join
I think its A & D
–> There is no SQL override in the Source Qualifier –> = No Union
agree
I’ll tip for “B&D”
Agree
agree
I’m not sure. There is no union here.
Union at DB level in SQ query is possible