Sub-Pages

BO DI Online Training

BO DI Online Training

BO DI Course Details

Business Objects Data Integrator (BO DI) is a data integration and ETL tool. It was previously called as ActaWorks. Join Mantra Online Trainings and learn BO DI course completely. Following are the course details.

 

INTRODUCTION

• DATA INTEGRATOR PRODUCT OVERVIEW
• Introduction
• Data Integrator design
• Data Integrator objects

 

DEFINING SOURCE & TARGET METADATA IN DATA INTEGRATOR

• Logging into the repository
• Defining a data source
• Importing meta data
• Defining a file format

 

OBI COMPONENTS

• OBI Administration Tool
• OBI Answers
• Intelligence dashboards

 

POPULATING THE SALES ORG DIMENSION FROM A FLAT FILE

• Objects and their hierarchical relationships
• Adding a new project
• Adding a job
• Adding a work flow
• About data flows
• Adding a data flow
• Defining the data flow
• Validating the data flow

 

ADDRESSING ERRORS

• Saving a project
• Executing the jobs
• Deleting objects

 

POPULATING THE CUSTOMER DIMENSION FROM A RELATIONAL TABLE

• Adding CUST dim job and work flow
• Adding CUST dim data flow
• Defining the CUST dim data flow
• Validating the CUST dim data flow
• Executing the CUST dim job
• Using the interactive debugger

 

POPULATING THE MATERIAL DIMENSION FROM AN XML FILE

• Adding material dim job ,work and data flow
• Importing a document type definition
• Defining the material dim data flow
• Validating the material dim data flow
• Leveraging the XML-PIPE line

 

POPULATING SALES FACT TABLE FROM MULTIPLE RELATIONAL TABLES

• Using meta data reports

 

CHANGED DATA CAPTURE

• Adding and defining the initial load job
• Adding and defining the delta-load job
• Executing the jobs

 

DATA QUALITY

• Overview
• Viewing profile statistics
• Defining a validation transform based on data profile statistics
• Auditing a data flow
• Viewing audit details in operational DASHBOARD reports

 

RECOVERY MECHANISMS

• Creating a recoverable work flow manually
• Adding the job and defining local variables
• Specifying a recoverable job
• Status of the exercise
• Executing the job
• Data Integrator Automated recovery properties

 

MULTI USER DEVELOPMENT

• Introduction
• Preparation
• Creating a central repository
• Creating two local repositories
• Associating repositories to your job server
• Defining connections to the central repository
• working in a multi user environment

 

EXTRACTING SAP R/3 DATA

• an SAP R/3 data store
• Importing metadata for SAP R/3 source tables
• Repopulating the customer dimension table
• Adding the SAP-CUST dim job ,workflow, and data flow
• Defining the SAP-cust dim data flow
• Defining the R/3 data flow
• Validating the SAP-CUST dim dataflow
• Executing the SAP-CUST dim job