ExistBI delivers the latest 3-day DS10 Data Services – Platform and Transforms training at competitive rates. Our SAP BusinessObjects trainers are certified, enthusiastic and extremely experienced. We deliver custom and classic SAP Business Objects training curriculums in your office or via instructor-led virtual classroom to meet the needs of your organization.

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
Print Friendly, PDF & Email