Join the discussion
Question 1/28
You are reading a Sales Order table from the source and need to add the customer region information a from a customer table. The primary key of the customer table consists of the columns CUST_ID and VALID_FROM How would you desing the dataflow to get the region information that was valid at the ORDER_CREARTE_DATE?
Correct Answer: C
Add Comments
- Other Question (28q)
- Q1. You are reading a Sales Order table from the source and need to add the customer region in...
- Q2. You developed a batch job using SAP Data Services and want yo start an execution. How can ...
- Q3. You want to load data from an input table to an output table using the SAP Data Services Q...
- Q4. A target column named ZIP4 requires the input of the source columns: POSTCODE and EXTENSIO...
- Q5. You are loading a database table using SAP Data Services. Which loading options are valid?...
- Q6. In SAP Data services which function delivers the same results an nested 1FTHENELSE functio...
- Q7. You import a table from a database into a datastore. Which information is added into the S...
- Q8. In SAP Data Services what do you use implement a target-based delta that deals with insert...
- Q9. You executed a job in development environment and it raised primary key violation error in...
- Q10. You want to execute two dataflows in parallel in SAP Data Services. How can you achieve th...
- Q11. A Map operation transform in SAP Data Services was used to modify the operation code of da...
- Q12. An SAP data services file format has a date column, but occasionally the file contains an ...
- Q13. From the account table you want to know how many accounts you have per account type. The A...
- Q14. You have to load a file that contains the following first three lines: YEAR; MONTH; PLAN_A...
- Q15. which transform are typically used to implement a slowly changing dimension of type 2 in S...
- Q16. The value of the DEPT ID is null (Exhibit) What is the output of this SAP Data Services fu...
- Q17. How do you view the data between transforms in SAP Data Services dataflow?...
- Q18. The SAP Data services merge transform is used to combine two datasets; the first has 3000 ...
- Q19. You built a delta load dataflow in SAP Data Services. This Dataflow is executed every nigh...
- Q20. Which feature in the SAP Data Services Management Console allows you to see the trend of t...
- Q21. You want to use on SAP data services transform to split your source vendor data into three...
- Q22. What operations can be pushed down in SAP Data Services?...
- Q23. You want to set up a new SAP Data Services landscape. You must also create new repositorie...
- Q24. You execute an SAP data services job with enable recovery activated. One of the dataflows ...
- Q25. What errors can you handle in SAP Services when you use a file format target?...
- Q26. Which of the following administrative tasks can you perform using the SAP Data Services Ma...
- Q27. You build a Data Warehouse with a date dimension in SAP Data Services. You decide to use t...
- Q28. You SAP Data Services job design includes an initialization script that truncates rows in ...
