PR000041 무료 덤프문제 온라인 액세스

Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:

• A.When the distinct check box is selected, every port in the sorter transformation will have the sort key selection enabled
• B.The Sorter transformation will utilize database indexes from the source database to perform the sort
• C.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.
• D.If the distinct check box is not checked, the sorter will produce one record per unique key

Given the picture shown below:

Identify all of the true and correct statements listed below. Note: The red (or gray) arrow points at the line in question.
The line on the left hand side of the picture which connects PRODUCT TO PRODUCT_COST : Choose 2 answers

• A.Describes an INNER JOIN between PRODUCT AND PRODUCT_COST
• B.Describes a secondary data flow needed for a sub-select process between PRODUCT AND PRODUCT_COST
• C.Describes a LEFT OUTER JOIN between PRODUCT AND PRODUCT_COST
• D.Can be created within Informatica PowerCenter

Refering to the Lookup transformation, which statement is correct and true?

• A.The lookup condition is designated in the ports tab interface via the "L" check box
• B.The lookup condition defines how much memory each of the two caches will consume
• C.The lookup condition is limited to only the equal operator
• D.The lookup condition defines the fields that are used in the search of the data

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.Joiner, Rank, Sorter
• D.Rank, Lookup, Aggregator

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.Value of the PREVI0US_STATE port is based upon its declared default value
• B.'CA'
• C.NULL
• D.STATE