This course will integrate a combination of instructor-led discussions and interactive workshops to illustrate the abilities of BusinesObjects XI Data Integrator tool. This seminar will focus on data warehousing concepts, role of the Data Integrator, defining source and target metadata, creating batch jobs, use of built-in transformations, creation of data filters, use of built-in functions, data flow optimization, perform data cleansing, role of variables and parameters, handling errors and exceptions, migration of projects, use of the Web administrator and managing our metadata.

Audience:

This course is designed for individual responsible for implementing, administering and managing projects that involve Data Integrator.

Prerequisites:

Each student should have a basic of data warehousing concepts, experience with an RDBMS and knowledge of SQL language and should have completed Introduction to Data Warehousing or understand the basic role of a Data Warehouse structures.

Objectives

• Understand Data Warehousing Concepts
• Illustrate the role of Data Integrator
• Defining Source and Target Metadata
• Creating a Batch Job
• Depict the validating, executing and debugging of jobs
• Demonstrate the use of built-in Transforms
• Illustrate the usage of built-in Functions
• Define the optimization of a Data Flow
• Illustrate how to easily manage change and metadata from disparate systems
• Depict how to audit data throughout the extraction, transformation, and load (ETL) process
• Depict the ability to cleanse our corporate data
• Demonstrate the use of variables, parameters and Scripting
• Understand the capturing of changes in data
• Improve data integrity through demonstrated data lineage
• Handling Errors and Exceptions
• Supporting a multi-user environment
• Migrating Projects between Design, Test and Production Phases
• Using the Web Administrator
• Understand how to manage metadata