Q1. 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.If InputValue = 2, the output will be routed to Group A only
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. Any positive number values other than 1 or 2 will be routed to the Default group
Correct Answer: B
Q2. Transformation: Referring to Active and Passive characteristics - Select the statement which is correct and true.
A.If a transformation's Active property is cleared or not enabled, the transformation becomes passive
B. A transformation is active if it does not change the number of rows in the pipeline
C. Transformations can be active and passive at the same time
D. A passive transformation will not change the number of rows in the pipeline
Correct Answer: D
Q3. The word FALSE is a valid Filter transformation condition?
A.True
B. False
Correct Answer: B
Q4. What function would transform 12.99 to 13.0 and 15.44 to 15.4? (choose one)
A.ROUND
B. TRUNC
C. INSTR
D. CONCAT
Correct Answer: A
$ 39
Reviews
There are no reviews yet.