DS10
Data Services – Platform and Transforms
- Solution:SAP BusinessObjects
Level:Details, Configuration & Transaction
Languages:English
Goals
- 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
Audience
- Data Consultant / Manager
- Solution Architect
Prerequisites
Essential
- Basic Knowledge of SQL
Recommended
- Data Warehousing Concepts
Course based on software release
- Data Services 4.2 SP8
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