QUESTION NO: 1
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
which transform are typically used to implement a slowly changing dimension of type 2 in SAP Data services?
3 correct answers
Correct Answer: A,B,D
Vote an answer
QUESTION NO: 2
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
What is the relationship between local variables and parameters in SAP Data Services? 2 correct answers
Correct Answer: B,D
Vote an answer
QUESTION NO: 3
In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?
In SAP Data Services you have a Validation Transform with the following two rules Rule #1: Action on Failure is 'Send to Pas' Rules#2: Action on Failure is 'Send to Fail.
Where are the records that fail both rule #1 and rule #2 sent?
Correct Answer: B
Vote an answer
QUESTION NO: 4
You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform? There are 2 correct answers
You want to load data from an input table to an output table using the SAP Data Services Query transform. How do you define the mapping of the columns within a Query transform? There are 2 correct answers
Correct Answer: C,D
Vote an answer
QUESTION NO: 5
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct
What operation can you push down to the database using a data transfer transform in SAP Data Services? 3 answers correct
Correct Answer: A,B,C
Vote an answer
QUESTION NO: 6
What does the expression SUBSTR(FIRST NAME, 1,3) return?
What does the expression SUBSTR(FIRST NAME, 1,3) return?
Correct Answer: A
Vote an answer
QUESTION NO: 7
The value of the DEPT ID is null
What is the output of this SAP Data Services function?
The value of the DEPT ID is null
What is the output of this SAP Data Services function?
Correct Answer: A
Vote an answer
QUESTION NO: 8
How do you view the data between transforms in SAP Data Services dataflow?
How do you view the data between transforms in SAP Data Services dataflow?
Correct Answer: B
Vote an answer