PR000041 試験問題を無料オンラインアクセス

A Router transformation has the following group filter conditions:
-Group A: InputValue = 2 -Group B: InputValue > 1 -Default group
The InputValue Is an integer port. Identify which of the following statements is correct. (Choose one)

• A.Any positive number values other than 1 or 2 will be routed to the Default group
• B.If InputValue = 2, the output will be routed to Group A only
• C.If InputValue = 2, the router will fail, since rows cannot be routed to multiple groups
• D.If InputValue = 2, the output will be routed to both groups A and B

Which is the correct priority of assigning a mapping variable?

• A.Repository value, declared initial value, default value
• B.Session parameter file, workflow parameter file, repository value, declared initial value
• C.Repository value, workflow parameter file, pre-session assignment, session parameter file, default value
• D.Workflow parameter file, session parameter file, pre-session assignment, repository value, declared initial value, default value

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.Both Pipelines should be cached for performance reasons
• B.Pipeline A
• C.Pipeline B
• D.Pipeline B if and only if Pipeline A is sorted

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

• A.The SQL transformation in script mode can execute sql scripts containing individual select statements that return more than one record to the pipeline
• 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 query mode can execute multiple SQL statements where components of the SQL Statement can vary from one execution to the next
• D.In PowerCenter 9 the SQL transformation, in query mode, can only be active

Which of the following statements is correct on workflow events?

• A.A user-defined event can be created a-d raised in one workflow and then used In another
• B.A user-defined event can be created in either the Event Wait or Event Raise task
• C.A predefined (or file-wait) Event Wait task waits for a file to appear at the specified location. As soon as the file appears, the event succeeds and the file can be processed by the subsequent mapping
• D.A predefined (or file-wait) Event Wait waits for a file to appear at the specified location. As soon as the file appears, it is deleted and the subsequent task will start.