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 both groups A and B
• 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 Group A only

Comment: *

Name: *

Email: *

Verification: *

Referring to a lookup transformation: Which of the following statements are true and correct?

• A.The data cache contains all of the fields in the lookup transformation
• B.The lookup index cache file contains a searchable index of the records based on the lookup condition
• C.The caching of a flat file is optional if the data in the flat file is sorted
• D.When lookup caching is unchecked, PowerCenter will read from a locally stored cache file

Comment: *

Name: *

Email: *

Verification: *

From within your folder, is it possible to make a non-reusable copy of a reusable transformation for use in a mapping?

• A.No
• B.Yes' by first clicking the Ctrl key and then dragging the reusable object into the mapping
• C.Yes, by first selecting the reusable object and while dragging the object into your mapping, hold the Ctrl key down
• D.Yes, by dragging the reusable object into your mapping and unchecklng the Reusable checkbox

Comment: *

Name: *

Email: *

Verification: *

Which statement on workflows is correct?

• A.In a default configuration, a workflow must contain at least one session task
• B.A workflow can contain multiple start points
• C.In a default configuration, a workflow parameter file overrides all parameter files in underlying sessions
• D.Another workflow cannot be executed from within a workflow

Comment: *

Name: *

Email: *

Verification: *

Assuming that the value of Fl is 12 as it enters the decode statement, which of the following decode statements will produce the value V? Choose 2 answers

• A.Option C
• B.Option B
• C.Option A
• D.Option D

Comment: *

Name: *

Email: *

Verification: *