Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

SAP Learning

Data Services - Platform and Transforms

via SAP Learning

Go to class Write review
Corporate Finance Institute Ad

Get 35% Off CFI Certifications - Code CFI35

Learn More → Scrimba Ad

Our career paths help you become job ready faster

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it

This course will give Developers and Consultants deep knowledge about SAP Data Services, such as installation, scheduling, security and configuration 

Syllabus

  • Explaining SAP Data Services
    • Introducing SAP Data Services solution
    • Describing the object model
    • Explaining SAP Data Services
  • Accessing data
    • Connecting to databases or applications using Datastores
    • Accessing files using Flat File Formats
    • Accessing data
  • Developing jobs and data flows
    • Creating Batch Jobs
    • Creating Data Flows
    • Documenting Jobs
    • Developing jobs and data flows
  • Troubleshooting batch jobs
    • Validating Jobs
    • Testing Jobs
    • Debugging Data Flows
    • Troubleshooting batch jobs
  • Using functions, scripts, and variables
    • Computing data using built-in functions
    • Designing independent reusable objects with variables and parameters
    • Initializing variables using scripts
    • Reusing logic with a custom function
    • Using jobs in different system configurations
    • Using functions, scripts, and variables
  • Querying data with Platform transforms
    • Building new data sets with the Query transform
    • Choosing between lookup function and join operation
    • Using the SQL Transform
    • Querying data with Platform transforms
  • Splitting and combining data with Platform transforms
    • Splitting data with the Case transform
    • Splitting data with the Validation Transform
    • Combining data with the Merge transform
    • Splitting and combining data with Platform transforms
  • Handling errors and recovering from failure
    • Auditing dataflows
    • Setting up error handling
    • Using automatic recovery mode
    • Handling errors and recovering from failure
  • Updating data
    • Bringing changes to the target table
    • Using Source-Based Changed Data Capture (CDC)
    • Using Target-Based Changed Data Capture (CDC)
    • Updating data
  • Designing advanced ETL scenarios using SAP Data Services Integrator transforms
    • Describing SAP Data Services Integrator transforms
    • Converting columns to rows using the Pivot transform
    • Designing advanced ETL scenarios using SAP Data Services Integrator transforms
  • Optimizing Performance
    • Optimizing data flows using the Data Transfer transform
    • Setting options to improve performance
    • Optimizing Performance

Reviews

Start your review of Data Services - Platform and Transforms

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.