BO DI (Duration: 30 Hrs)

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 o Defining the data flow o 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 o Creating a central repository o Creating two local repositories o Associating repositories to your job server o Defining connections to the central repository o 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