Online Access Free PR000041 Exam Questions

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

• A.In PowerCenter 9 the SQL transformation, in query mode, can only be active
• B.The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
• C.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 (!)
• D.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

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 Mapping tab, choose the correct mapping to reassociate with the session ask, then Save and rerun the process
• B.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
• C.At run time, when the workflow is executed, chose the session task with the correct mapping associated
• D.None of the above

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

• A.Pipeline B
• B.Pipeline A
• C.Pipeline B if and only if Pipeline A is sorted
• D.Both Pipelines should be cached for performance reasons

Which statement is correct regarding User-Defined Functions (UDF)?

• A.Can be used in mappings and transformations however not in mapplets
• B.Can be reused from a shared folder as shortcut
• C.A UDF name can contain letters, numbers and underscores
• D.Can contain Java code snippets

What is the first column of the bad file?

• A.Column Indicator
• B.Reject reason
• C.Row Indicator
• D.Overflow Indicator