1.
A Pipeline Normalizer transformation will reflect one input port for each occurs value which Is greater than 1.
2.
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
3.
The Informatics Date/Time datatype supports values up to which level? (choose one)
4.
Regarding the Sorter transformation and assuming that Powercenter is not utilizing Pushdown Optimization, select the statement which is correct and true:
5.
Referring to a lookup transformation: Which of the following statements are true and correct?
6.
When using the Joiner transformation and assuming that you are not employing the Push Down Optimization feature, which statement is correct?
7.
Referring to the Java transformation: select the statement below which is correct and true.
8.
Given the picture shown below: How many columns would be selected from the database using PowerCenter's generated sql statement?
9.
What does the function SETVARIABLE ($$Variable, value) do?
10.
A workflow has a session task. Both workflow and session each have been assigned a different parameter file. Which value will be set for $$ParameterValue in the session when using the following two parameter files?"
Workflow Parameter file:
[Global] $$ParameterValue=l
[Session] $$ParameterValue=2
Session Parameter file:
[Global] $$ParameterValue=3
[Session] $$ParameterValue=4