Data Services - Platform and Transforms

Course Details
Code: DS10-v015
Tuition (USD): $2,250.00 • Virtual (3 days)
$2,250.00 • Classroom (3 days)

Skills Gained

  • 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

Who Can Benefit

  • Data Consultant / Manager
  • Solution Architect

Prerequisites

  • Essential:
       -Basic Knowledge of SQL
  • Recommended:
       -Data Warehousing Concepts

Course Details

Course 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

Course based on software release

  • Data Services 4.2 SP8