Which of the following statements regarding mapplets are correct and true?
Answer : B
Which of the following statments are valid for Active and Passive Transformations? Choose
2 answers
Answer : A,D
A Pipeline Normalizer transformation will reflect one input port for each occurs value which
Is greater than 1.
Answer : A
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
Answer : A,C
The Informatics Date/Time datatype supports values up to which level? (choose one)
Answer : C
Regarding the Sorter transformation and assuming that Powercenter is not utilizing
Pushdown Optimization, select the statement which is correct and true:
Answer : A
Referring to a lookup transformation: Which of the following statements are true and correct?
Answer : B
When using the Joiner transformation and assuming that you are not employing the Push
Down Optimization feature, which statement is correct?
Answer : B
Referring to the Java transformation: select the statement below which is correct and true.
Answer : A
Given the picture shown below:
How many columns would be selected from the database using PowerCenter's generated sql statement?
Answer : C
What does the function SETVARIABLE($$Variable, value) do?
Answer : D
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
Answer : A
Subqueries can be used in the SQL override for uncached lookup transformations.
Answer : B
Based upon the graphic below, which answer correctly discribes the outcome of this workflow's execution given the start method: (The workflow is valid)
Workflows > Start Workflow
Answer : D
Which attributes of a reusable Expression transformation can be edited within the Mapping
Designer workspace?
Answer : B