BusinessObjects Data Integrator XI Extracting, Transforming and Loading Data (DM370R2)
Using Data Integrator you create projects 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. In this course you learn about data transformation jobs, techniques for capturing changes in data, handling errors, multi-user environment tasks, administering server and migration basics. You also learn how to use tools to audit, profile data, and manage metadata to assist you in the design and implementation of your ETL project.Activities in this course guide you through creating a few dimensions and a fact table. These smaller activities focus on the tools and features discussed within each lesson. You will have a chance to apply different concepts learned from a few combined lessons in workshops. At the end of the course, you will be able to put into practice what you have learned in terms of data flow design in a final workshop.
Who Should Attend
This course is designed for individuals responsible for implementing ETL projects (batch-mode), administering and managing projects that involve Data Integrator. This course applies to BusinessObjects XI R1, XI R2 , 6.5, 6.x and 5.xDelivery Options
This course is offered for onsite delivery, customized delivery, and onsite mentoring.Course Duration
Four daysPrerequisities
Database & SQL knowledge.What You Will Learn
- Datawarehousing Concepts
- Understanding Data Integrator
- Defining Source and Target Metadata
- Validating, Tracing and Debugging Jobs
- Creating a Batch Job
- Using Built-in Transforms and Nested Data
- Using Built-in Functions
- Using Data Integrator Scripting Language and Variables
- Capturing Changes in Data
- Handling Errors and Auditing
- Supporting a Multi-user Environment
- Migrating Projects
- Using the Administrator
- Profiling Data
- Managing Metadata
