Summer Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: exc65

In the Expression transformation graphic below, what is the value of the PREVIOUS_STATE port for row 2, given that the value for the STATE port was 'CA' for row 1?

A.

STATE

B.

'CA'

C.

NULL

D.

Value of the PREVI0US_STATE port is based upon its declared default value

Which combination of Transaction Control transformation and target type results in an invalid mapping? (choose one)

A.

Dynamic MQ Series target

B.

MS target

C.

Relational target

D.

XML target

What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)

A.

ROUND

B.

TRUNC

C.

INSTR

D.

CONCAT

Referring to the Sequence Generator transformation, which statement is correct and true?

A.

The NextVal column produces the next number in the sequence

B.

The cycle check box on the properties tab turns on a feature that randomizes the numbers but still produces a unique set of numbers for the sequence

C.

The default ending value for a PowerCenter 9.x Sequence Generator is 2,147,483,647

D.

The Sequence Generator contains a single input port that represents the initial starting point of the sequence

If after running a session task, it has been determined that the incorrect mapping was run for that session task, which of the following actions could be attempted?

A.

Edit the session task and from the General tab, choose the correct mapping to reassociate with the session task, then Save and rerun the process

B.

At run time, when the workflow is executed, chose the session task with the correct mapping associated

C.

Edit the session task and from the Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process

D.

None of the above

The constant DD_INSERT may be used in an expression within which transformation or transformations? (choose one)

A.

Expression and Update Strategy

B.

Update Strategy

C.

Update Strategy and Lookup

D.

Expression, Aggregator, and Update Strategy

Referring to an Unconnected Lookup transformation: Which one of the following is true? (choose one)

A.

An unconnected lookup can return multiple rows while a connected lookup may return only one

B.

Both connected and unconnected lookups can return multiple rows

C.

An unconnected lookup may return only one value while a connected lookup may return multiple rows

D.

Both connected and unconnected lookups can return only one row

What is the first column of the bad file?

A.

Reject reason

B.

Column Indicator

C.

Overflow Indicator

D.

Row Indicator

Which of following statements is valid for Dynamic lookups?

A.

Dynamic caching cannot be enabled on a lookup that returns multiple rows per search

B.

A dynamic lookup can only be used with insert mappings, i.e. no update strategies are allowed and the session should be configured as Insert

C.

A dynamic lookup must be cached and persistent

D.

It is possible to update and delete records in a dynamic lookup

Which of these statements on worklets is correct?

A.

Worklets can be nested

B.

A worklet must be a reusable object

C.

A worklet can be executed separately

D.

A worklet does not have to contain a Start task