C_DS_42 Exam Question 61

Which repository types are used in SAP Data Services? 2 correct
  • C_DS_42 Exam Question 62

    In addition to the main databases for source information, records for orders are stored in flat files. You need to extract data from these flat files, and so must create the appropriate file format for the extraction. Create a file format Orders_Format for an orders flat file so that you can use it as a source object for extraction. (Validate the correct statement).
  • C_DS_42 Exam Question 63

    When evaluating the customer data for Alpha Acquisitions, you discover a data entry error.
    The contact title of "Account Manager" has been entered as "Accounting Manager". You must correct these entries before it is moved to the data warehouse.
    How to Using the Function wizard, create a new expression for the column using the search_replace function found under the category of
    "String" functions.
  • C_DS_42 Exam Question 64

    You create a file format in SAP Data Services
    What properties can you set for a column?
    Note: There are 3 correct answers to this question.
  • C_DS_42 Exam Question 65

    You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables.
    Use the sum function to calculate the total value of orders in the Order_Details table.
    How to create a new batch job called Alpha_Order_Sum_Job with a data flow Alpha_Order_Sum_DF .