BO DI Online Training

BO DI Online Training
123 Trainings is providing best BO DI Online Training from Hyderabad India, We proud to say that we are only the excellent Online BO DI Training providers across globe. We will give you Online support 24/7 days for the students of 123 Trainings. Our BO DI Online Training faculty is Certified, Highly Qualified and dedicated. Our BO DI Online Training course content designed as per the latest trend. In this BO DI Online Training course Our faculty is going to cover all the concepts in detail and real time scenarios as Our BO DI Online Training faculty is Highly experienced.
123 Trainings is the best and excellent Online Training Institute In Hyderabad, India.

INTRODUCTION TO DATAWARE HOUSING (DWH)
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

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