Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Informatica Certified Professional ICP Program PR000041 Full Course Free

Page: 2 / 3
Total 70 questions

PowerCenter Data Integration 9.x:Developer Specialist Questions and Answers

Question 5

Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.

Options:

A.

If a transformation's Active property is cleared or not enabled, the transformation becomes passive

B.

A transformation is active if it does not change the number of rows in the pipeline

C.

Transformations can be active and passive at the same time

D.

A passive transformation will not change the number of rows in the pipeline

Question 6

Which of the following Is NOT true of Aggregate functions?

Options:

A.

You can place an aggregate function in a variable port

B.

You can add a filter condition to calculate values for specific rows In the selected ports

C.

You can use operators to perform arithmetic within the function

D.

You can calculate a single value for all rows in a group

Question 7

By default workflows always have a run status of succeeded. Identify the methods to change the run status of the workflow. For the puposes of this question, assume there are no worklets in the workflow.

Options:

A.

Check the Fail Parent if this task fails option box on the session task

B.

Use a Control Task with a Control Option setting of Fail Me

C.

Use an assignment task to call the ERROR() function

D.

Use a command task to set the value of $RC to a negative number

Question 8

A workflow has a session task. Both workflow and session each have been assigned a different parameter file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"

Workflow Parameter file:

[Global] $$ParameterValue=l

[Session] $$ParameterValue=2

Session Parameter file:

[Global] $$ParameterValue=3

[Session] $$ParameterValue=4

Options:

A.

1

B.

2

C.

3

D.

4

Page: 2 / 3
Total 70 questions