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

examout.co

The word FALSE is a valid Filter transformation condition?

A.

True

B.

False

Which statement on workflows is correct?

A.

In a default configuration, a workflow must contain at least one session task

B.

A workflow can contain multiple start points

C.

In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions

D.

Another workflow cannot be executed from within a workflow

Given a Union transformation with 2 input groups, which statement is correct and true?

A.

Both input groups must have matching ports. The precision, datatype, and scale must be identical across both input groups.

B.

Either input group can have a port that does not match the other input group. The precision, datatype, and scale does not have to be identical across both input groups.

C.

When merging the 2 groups of data together, the Union transformation will remove duplicate rows.

D.

The port names in each input group can be named the same.

Which of these statements is correct concerning a Lookup transformation's persistent cache?

A.

A persistent cache is stored on disk, and must be named to make it useable in multiple mappings

B.

persistent cache is stored on disk, to refresh the cache the disk files must be deleted manually

C.

When the Integration Service cannot find the persistent cache file and the recache property is not set, the session fails

D.

A persistent cache can only be used by one mapping

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

A.

The transformation's name, one of its port's default values, the tracing level or a Metadata Extension

B.

The transformation's name or the tracing level

C.

The transformation's name, one of its port's default values or the tracing level

D.

The transformation's name is the only attribute that can be changed

How does a single joiner transformation join data?

A.

From 2 pipeline inputs

B.

From 3 pipeline inputs

C.

From n number of pipeline inputs assuming you have purchased the N-Joiner Option

D.

none of the above

When the Transformation Scope is set to All Input, which group of transformations listed below will always cause an upstream Transaction Control transformation to become ineffective? (choose one)

A.

Filter, Joiner, Rank

B.

Union, Filter, Aggregator

C.

Rank, Lookup, Aggregator

D.

Joiner, Rank, Sorter

Subqueries can be used in the SQL override for uncached lookup transformations.

A.

True

B.

False

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.

13 -Based on all of the links entering the Source Qualifier

C.

3 -Based on the all of the links between the Source Qualifier and the next transformation

D.

Unknown - We need to know how many columns the target has

Please choose one of the following. In a static, non-multi-row lookup,

A.

lf a lookup search does not find a value in the search data, then the row from which the search is produced is dropped so a balanced pipeline can be produced

B.

If a lookup search finds the search value in the lookup data but discovers that the fields that are being returned from the search are null, then the row from which the search is produced is dropped so that a balanced pipeline can be produced

C.

If the lookup finds two records that match the search key, it will return two records

D.

None of the above