Question 36

You modified an existing SAP data Services job. You notice that the run time is now longer then expected.
Where in SAP Data Services can you observe the progress of row counts to determine the location of a bottleneck
  • Question 37

    During development of a SAP Data Services dataflow, you find that the source system contains data inconsistencies.
    What transform allows you to define rules and monitor the conformance of the data for every load?
  • Question 38

    What operations can be pushed down in SAP Data Services?
  • Question 39

    In the Alpha Acquisitions database, the country for a customer is stored in a separate table and referenced with a code. To speed up access to information in the data warehouse, this lookup should be eliminated.
    Use the lookup_ext function to exchange the ID for the country name in the customers table for Alpha with the actual value from the country table.
    How to Execute the Alpha_NACustomer_Job with the default execution properties after saving all objects you have created.
  • Question 40

    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 Modify the data flow to send customers outside North America to a second template table, Alpha_Other_customer .