Question 31

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.
  • Question 32

    You have to load a file that contains the following first three lines:
    YEAR; MONTH; PLAN_AMOUNT
    2014;01;100.00
    2014;02;110.00
    What setting do you use when you created a file format for this?
  • Question 33

    You must ensure that all records from the Customer table in the Alpha database are being moved to the Delta staging database using the audit logs.
    In the Local Object Library, replicate the Alpha_NACustomer_DF data flow. Name the replicated data flow Alpha_AuditCustomer_DF . Add the replicated data flow to a new job, Alpha_AuditCustomer_Job . Set up auditing on the data flow Alpha_AuditCustomer_DF by adding an audit rule to compare the total number of records in the source and target tables.
    How to Add the Alpha_AuditCustomer_DF to the Alpha_AuditCustomer_Job .
  • Question 34

    ________for the user account through which SAP
    Data Services connects to this SAP application server.
  • Question 35

    What does the expression SUBSTR(FIRST NAME, 1,3) return?