A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements is correct on workflow events?

• A.A user-defined event can be created in either the Event Wait or Event Raise task
• B.A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.
• C.A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping
• D.A user-defined event can be created a-d raised in one workflow and then used In another

Comment: *

Name: *

Email: *

Verification: *

Which attributes of a reusable Expression transformation can be edited within the Mapping Designer workspace?

• A.The transformation's name or the tracing level
• B.The transformation's name, one of its port's default values or the tracing level
• C.The transformation's name is the only attribute that can be changed
• D.The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

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

Comment: *

Name: *

Email: *

Verification: *

Which of the following is a reusable task available in workflow manager?

• A.Command
• B.Assignment
• C.Decision
• D.Control

Comment: *

Name: *

Email: *

Verification: *