Want to pass your PowerCenter Data Integration 9.x:Developer Specialist PR000041 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Two pipelines (A and B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?
A. Pipeline A
B. Pipeline B
C. Both Pipelines should be cached for performance reasons
D. Pipeline B if and only if Pipeline A is sorted
When would a Lookup transformation be classified as active?
A. When the setting for lookup policy on multiple match is Use Any Value
B. A lookup cannot be an active transformation
C. When the lookup is configured to return multiple rows
D. A lookup is always active
When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?
A. The data from the detail pipeline Is used to build the cache files used In the join process
B. The data from the master pipeline is used to build the cache files used in the join process
C. The cache files are built according to a sql override found on the Joiner Properties tab
D. The Joiner transformation uses the database to build the join result