BO DI Online Training
LTS 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 LTS 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.
LTS 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
