PR000041 Exam Dumps - PowerCenter Data Integration 9.x:Developer Specialist

Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping

Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down

No

Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

When merging the 2 groups of data together, the Union transformation will remove duplicate rows.

The port names in each input group can be named the same.

The data from the detail pipeline Is used to build the cache files used In the join process

The data from the master pipeline is used to build the cache files used in the join process

The cache files are built according to a sql override found on the Joiner Properties tab

The Joiner transformation uses the database to build the join result

lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

If the lookup finds two records that match the search key, it will return two records

None of the above

Decision

Assignment

Control

Command

True

False

2 -Due to the line on the left hand side of the picture

13 -Based on all of the links entering the Source Qualifier

3 -Based on the all of the links between the Source Qualifier and the next transformation

Unknown - We need to know how many columns the target has