Online informatica training offersOnline SAP BODI Training. SAP BODI is most widely spread BI tool from SAP. Accepting the plenty of opportunities in the market, online informatica training provides Online SAP BODI Training by absolute time industry experts. Online SAP BODI Training advises trainees with superior and quality guidelines to advance the familiarity. Our trainers are real time certified industry experts having the ability of train to students in real time projects..
Course Duration: 30 Hours
- 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
- POPULATING THE SALES ORG DIMENSION FROM A FLAT FILE
- 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
