Duration
3 days
Goals
In this course 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 course would ideally suit delegates who are new to SAP Data Services.
Audience
- Data Consultant / Manager
- Solution Architect
Essential
- Basic Knowledge of SQL
Recommended
- Data Warehousing Concepts
Course based on software release
- Data Services 4.3
Content
- Data Services
- Defining Data Services
- Source and Target Metadata
- Defining Datastores in Data Services
- Defining a Data Services Flat File Format
- Batch Job Creation
- Creating Batch Jobs
- Batch Job Troubleshooting
- Writing Comments with Descriptions and Annotations
- Validating and Tracing Jobs
- Debugging Data Flows
- Auditing Data Flows
- Functions, Scripts, and Variables
- Using Built-In Functions
- Using Variables, Parameters, and Scripts
- 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
- Error Handling
- Setting Up Error Handling
- Changes in Data
- Capturing Changes in Data
- Using Source-Based Change Data Capture (CDC)
- Using Target-Based Change Data Capture (CDC)
- Data Services Integrator Transforms
- Using Data Services Integrator Transforms
- Using the Pivot Transform
- Using the Data Transfer Transform
Programme scope, delivery arrangements and suitability are confirmed during enquiry.