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