Can you use a Decode function to perform multiple searches based on a single search value?

• A.No
• B.Yes, but only if the port being searched Is sorted first
• C.Yes
• D.Yes, but only if the port is downstream of a router transformation

Comment: *

Name: *

Email: *

Verification: *

Referring to the SQL Transformation: which statements is correct and true.

• A.The SQL transformation in query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next
• B.When you bind a parameter to an input port, you identify the port by name in the query. The SQL Editor encloses the name in exclamation question marks (!)
• C.The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
• D.In PowerCenter 9 the SQL transformation, in query mode, can only be active

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

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

• A.XML target
• B.MS target
• C.Relational target
• D.Dynamic MQ Series target

Comment: *

Name: *

Email: *

Verification: *