SAP - Course Details

SAPBODS(WNADSV) SAP BusinessObjects Data Services (WNADSV)

SAP Course Description:
In this workshop, delegates will learn about creating, executing, and transforming batch jobs using functions, scripts, and basic transforms to change the structure and formatting of data. This workshop would ideally suit delegates who are new to SAP Data Services. Delegates will learn about creating, executing and troubleshooting Data Quality jobs using Data Quality specific transforms. These transforms will be used for cleansing address and firm data, and match and consolidate records.
SAP Course Duration:
5 DAYS
SAP Course Target Audience:
This five day workshop is designed for individuals responsible for implementing, administering and managing data integration and data quality projects.
SAP Course Prerequisite:
Data warehousing and ETL concepts,Experience with MySQL and SQL language,Experience using functions, elementary procedural language programming and flow-of-control,Data warehouse fundamentals,Data warehouse architecture and modelling,Data staging and data quality issues
Course Content:
  • Describing Data Services 
       -Describe the purpose of Data Services 
       -Describe Data Services Architecture 
       -Define Data Services Objects 
       -Use the Data Services Designer Interface

  • Defining Source and Target Metadata 
       -Use Datastores 
       -Use Datastore and System Configuration 
       -Define File Formats for Flat Files 
       -Define File Formats for Excel Files 
       -Define File Formats for XML Files

  • Creating Batch Jobs 
       -Work with Objects 
       -Create a Data Flow 
       -Use the Query Transform 
       -Use Target Tables 
       -Execute the Job

  • Troubleshooting Batch Jobs 
       -Use Descriptions and Annotations 
       -Validate and Tracing Jobs 
       -Use View Data and the Interactive Debugger 
       -Use Auditing in Data Flows

  • Using Functions, Scripts and Variables 
       -Define Built-In Functions 
       -Use Functions in Expressions 
       -Use the Lookup Function 
       -Use the Decode Function 
       -Use Variables and Parameters 
       -Use Data Services Scripting Language 
       -Script a Custom Function

  • Using Platform Transforms 
       -Describe Platform Transforms 
       -Use the Map Operation Transform 
       -Use the Validation Transform 
       -Use the Merge Transform 
       -Use the Case Transform 
       -Use the SQL Transform

  • Setting Up Error Handling 
       -Set up recoverable Workflows

  • Capturing Changes in Data 
       -Describe the options for updating changes to data 
       -Explain the purpose of Changed Data Capture(CDC) 
       -Explain the roles of surrogate keys in managing changes to data 
       -Use and define the differences between source-based and target- based CDC

  • Using Data Integrator Transforms 
       -Describe the Data Integrator transforms 
       -Use the Pivot transform 
       -Use the Hierarchy Flattening transform 
       -Describe performance optimization 
       -Use the Data Transfer transform 
       -Use the XML Pipeline transform

  • Cleansing Address Data 
       -Explain the benefits of address cleansing 
       -Identify the supported formats and types of address data 
       -Describe the Address Cleanse transforms in Data Quality 
       -Define how to handle address data from different countries 
       -Configure an Address Cleanse transform 
       -Define how to cleanse transactional data

  • Cleansing Firm and Name Data 
       -Cleansing Name, Firm, and Product Data 
       -Explain the benefits of data cleansing 
       -Describe the Data Cleanse transforms in Data Quality 
       -Define how to handle types of name and firm data 
       -Configure a Data Cleanse transform 
       -Define the purpose of parsing dictionaries 
       -Customize dictionary entries 
       -Set up Universal Data Cleanse for operational data •

  • Matching and Consolidating Records 
       -Select a matching strategy 
       -Understand match sets, match levels, match criteria, and break grou 
       -Use the Match Wizard to configure the Match transform 
       -Describe matching methods 
       -Modify the Match transform using the Match Editor 
       -Configure post-match processing operations 
       -Understand corporate householding and associative matching