Free PR000041 Exam Dumps Preview

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

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

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

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

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

Transformations can be active and passive at the same time

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

A workflow can contain multiple start points

Another workflow cannot be executed from within a workflow

The caching of a flat file is optional if the data in the flat file is sorted

When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

The data cache contains all of the fields in the lookup transformation

Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST

Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST

When transformation scope is set to a value of transaction, the sorter will sort on every record in the

pipeline before it releases any data. The intermediate sort file will have markers for each transaction.

If the distinct check box is not checked, the sorter will produce one record per unique key

The Sorter transformation will utilize database indexes from the source database to perform the sort

The lookup condition defines how much memory each of the two caches will consume

The lookup condition is limited to only the equal operator

The lookup condition is designated in the ports tab interface via the "L" check box

Pass-through

Not a valid partition points

Based on the transformation scope

STATE

NULL

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

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

A dynamic lookup must be cached and persistent

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

3 fields are in the index cache and 2 fields are in the data cache

2 fields are in the index cache and 3 fields are in the data cache

2 fields are in the index and 5 fields are in the data cache