ExistBI delivers the latest 3-day DS10 Data Services – Platform and Transforms training to customers in North America, UK and Europe. Our SAP Data Services trainers are certified, enthusiastic and extremely experienced. We deliver custom and classic agendas in your office or via instructor-led virtual classroom to meet the needs of your org.
Goals
- Define Data Services
- Define Source and Target Connections
- Trace, Validate, and Debug Data Services Jobs
- Use Data Services Transforms
- Implement Change Data Capture in Data Services
Audience
- Data Consultant/Manager
- Solution Architect
- Super / Key / Power User
Pre-requisites
- Essential: Basic knowledge of SQL
- Recommended: Data Warehousing Concepts
Official Agenda
Module 1: Data Services
- Defining Data Services
Module 2: Source and Target Metadata
- Defining Datastores in Data Services
- Defining a Data Services Flat File Format
Module 3: Batch Job Creation
- Creating Batch Jobs
Module 4: Batch Job Troubleshooting
- Writing Comments with Descriptions and Annotations
- Validating and Tracing Jobs
- Debugging Data Flows
- Auditing Data Flows
Module 5: Functions, Scripts and Variables
- Using Built-In Functions
- Using Variables, Parameters, and Scripts
Module 6: Platform Transforms
- Using Platform Transforms
- Using the Map Operation Transform
- Using the Validation Transform
- Using the Merge Transform
- Using the Case Transform
- Using the SQL Transform
Module 7: Error Handling
- Setting Up Error Handling
Module 8: Changes in Data
- Capturing Changes in Data
- Using Source-Based Change Data Capture (CDC)
- Using Target-Based Change Data Capture (CDC)
Module 9: Data Services Integrator Transforms
- Using Data Services Integrator Transforms
- Using the Pivot Transform
- Using the Data Transfer Transform