BO DI Online Training

BO DI Online Training :

  • Introduction to DWH
  • Characteristics of DWH
  • OLTP Vs OLAP Databases
  • Different Approaches of DWH (Kimball Vs Inmon)
  • Data mart Vs Data Warehouse
  • Fact Table Vs Dimension Table
  • Concepts of Schemas (Star schema & Snowflake schema)
  • Industry leading ETL and Reporting tools

 

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
HOMEWHY USOUR STRATEGY
PROJECT SUPPORTBLOGBECOME AN Instructor
CONTACT USWEB DESIGNINGOUR SERVICES
LEARNER SIGN UPTRAINER SIGN UPREFER A FRIENDSITEMAP
Copy rights © HyderabadSys.com