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