In this course, students will learn how to define data services, source, and target connections, as well as use data services transforms and implement change in data capture within data services.

starstarstarstarstar_half

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

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

1

  • Data Services

  • Defining Data Services
2

  • Source and Target Metadata

  • Defining Datastores in Data Services
    Defining a Data Services Flat File Format
3

  • Batch Job Creation

  • Creating Batch Jobs
4

  • Batch Job Troubleshooting

  • Writing Comments with Descriptions and Annotations
    Validating and Tracing Jobs
    Debugging Data Flows
    Auditing Data Flows
5

  • Functions, Scripts, and Variables

  • Using Built-In Functions
    Using Variables, Parameters, and Scripts
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
7

  • Error Handling

  • Setting Up Error Handling
8

  • Changes in Data

  • Capturing Changes in Data
    Using Source-Based Change Data Capture (CDC)
    Using Target-Based Change Data Capture (CDC)
9

  • Data Services (Integrator) Platform Transforms

  • Using Data Services (Integrator) Platform Transforms
    Using the Pivot Transform
    Using the Data Transfer Transform

Audience

The primary audience for this course are Application Consultants, Developers, Developer Consultants, and Technology Consultants.

Language

English

Prerequisites

Basic knowledge of SQL and data warehousing concepts.

$2,601

Length: 3.0 days (24 hours)

Level:

Not Your Location? Change

Course Schedule:

Schedule select
04
Dec
Monday
9:30 AM ET -
5:30 PM ET
Filling Fast
Available
Loading...