BOI200 - Data Integrator XI: Extracting, Transforming & Loading Data
Description: Using Data Integrator, you can create jobs that Extract, Transform and Load (ETL) data
from disparate sources to deliver more timely and accurate data that end users at your organization
can trust. This course provides activities that walk you through setting a connection to your data
source, creating and troubleshooting an ETL batch job, managing metadata, and using the Web
Administrator to administer batch jobs.
Student Profile: This course is designed primarily for individuals responsible for implementing projects involving the extraction, transformation and loading of data in batch jobs, administering and managing projects that involve Data Integrator.
Prerequisites: To be successful, learners who attend this course must have:
- Knowledge of data warehousing concepts
- Experience with Microsoft SQL Server
- Knowledge of normal forms of data & SQL language
- Experience using functions, elementary procedural programming & flow-of-control statements. For example: If, Else, While, Loop.
Duration: 4 days
Objectives: After completing the course, learners will be able to:
- Describe BusinessObjects Data Integrator architecture
- Define source & target metadata to import into your ETL jobs
- Create a batch job
- Validate, trace & debug batch jobs
- Use built-in Transforms & Functions to support data flow movement requirements
- Optimize data flow
- Use variables, parameters & Data Integrator Scripting Language
- Capture changes in data
- Handle errors & exceptions
- Support a multi-user environment, administer batch jobs & migrate projects using datastore & system configurations
- Manage metadata
