BOI300 - Data Integrator XI 3.0: Core Concepts

Description: In this three-day course, you will learn about creating, executing, and transforming batch jobs, using functions, scripts, and transforms to change the structure and formatting of data, handling errors, and capturing changes in data.

Student Profile: This course is designed for anyone responsible for implementing, administering, and managing data integration projects.

Objectives: To learn best-practice methodology for integrating disparate data sources to deliver timely and accurate data that end users in an organization can trust. By being able to create efficient data integration projects, the transformed data will help improve operational and supply chain efficiencies, enhance customer relationships, create new revenue opportunities, and optimize return on investment from enterprise applications.

Prerequisite Knowledge / Experience: To be successful in this course, you must have the following:

Knowledge of data warehousing & ETL concepts
Experience with MySQL & SQL language
Experience using functions, elementary procedural programming & flow-of-control statements, such as If-Then-Else & While Loop statements

It is recommended you review these articles prior to attending the course:

Data Warehouse Fundamentals: TCO Starts With the End User and Fact Tables and Dimension Tables
Data Warehouse Architecture & Modeling: There Are No Guarantees
Advance Dimension Table Topics: Surrogate Keys, It's Time for Time, and Slowly Changing Dimensions
Industry- & Application-Specific Issues: Think Globally, Act Locally
Data Staging & Data Quality: Dealing with Dirty Data

Duration: 3 days

Curriculum: Course topics include:

Describing Data Services

Describe the purpose of Data Services
Describe Data Services architecture
Define Data Services objects
Use the Data Services Designer interface

Defining Source & Target Metadata

Use datastores
Use datastore & system configurations
Define file formats for flat files
Define file formats for Excel files
Define file formats for XML files

Creating Batch Jobs

Work with objects
Create a data flow
Use the Query transform
Use target tables
Execute the job

Troubleshooting Batch Jobs

Use descriptions & annotations
Validate & trace jobs
Use View Data & the Interactive Debugger
Use auditing in data flows

Using Functions, Scripts & Variables

Define built-in functions
Use functions in expressions
Use the lookup function
Use the decode function
Use variables & parameters
Use Data Services scripting language
Script a custom function

Using Platform Transforms

Describe platform transforms
Use the Map Operation transform
Use the Validation transform
Use the Merge transform
Use the Case transform
Use the SQL transform

Setting Up Error Handling

Set up recoverable work flows

Capturing Changes in Data

Update data over time
Use source-based CDC
Use target-based CDC

Using Data Integrator Transforms

Describe Data Integrator transforms
Use the Pivot transform
Use the Hierarchy Flattening transform
Describe performance optimization
Use the Data Transfer transform
Use the XML Pipeline transform