Using the Properties view of a Session task from the Workflow Monitor, the reason for a session's failure can possibly be determined?

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Given the picture shown below:

How many columns would be selected from the database using PowerCenter's generated sql statement?

• A.13 - Based on all of the links entering the Source Qualifier
• B.2 - Due to the line on the left hand side of the picture
• C.Unknown - We need to know how many columns the target has
• D.3 - Based on the all of the links between the Source Qualifier and the next transformation

Comment: *

Name: *

Email: *

Verification: *

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

• A.Return
• B.Output
• C.lnput
• D.Variable

Comment: *

Name: *

Email: *

Verification: *

When would a Lookup transformation be classified as active?

• A.When the lookup is configured to return multiple rows
• B.When the setting for lookup policy on multiple match is Use Any Value
• C.A lookup is always active
• D.A lookup cannot be an active transformation

Comment: *

Name: *

Email: *

Verification: *

Which of the following is true about database connections?

• A.Connections may only be created in the Workflow Manager for PowerCenter Repositories and only in the Developer for the MRS
• B.PowerCenter connections may be created In either the Administrator or the Workflow Manager
• C.MRS connections may be created in either the Workflow Manager or the Administrator
• D.Connections may be created in the Administrator for the MRS and in the Workflow Manager for PowerCenter Repositories

Comment: *

Name: *

Email: *

Verification: *