SAP BODS Training

SAP BODS Training

SAP BODS is an ETL tool currently acquired by SAP used for integration with all types of disparate systems, extracting data from them, transforming them into meaningful information and loading them into all types of systems.

It is tightly integrated with SAP systems and hence really a good tool to migrate data from legacy systems to SAP systems with ease and less development efforts with effective debugging and monitoring capabilities.

Course Information

  • Course Duration : 40 Hours
  • Training Timings : Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
  • Training Method : Instructor Led Online Training
  • Study Material : Soft Copy

Prerequisite

Instructor Led SAP BODS Online Training

Flexible Time At Your Convenience

Over 10,000+ Professionals Trained Across 35 Countries

24×7 Live Support via Chat, Mail and Phone

Corporate Training and On-Job Support


Course Content

Definition

Methodologies

Dimensional Modeling

DW Lifecycle

DW Challenges

ETL  introduction

Staging Area

Business Rules

Performance

Slowly Changing Dimensions

Surrogate Keys

Fatcs and Dimension Tables

Different ETL Tools

History

Components

Architecture

Purpose of Data Services

Data Services architecture

Define Data Services objects

Data Services Designer interface

Object Hoerarchy

Jobs

Workflows

Data Flows

Data Stores

File formats for flat files

File formats for Excel files

File formats for XML files

Lab Exercises

Environment setup

Creating repository

Setting Job Server

Setup for realtime operation

Setting multiple datastores

Starting Job servers

Lab Exercises

Source and Target Metadata

Data Stores

File formats for flat files

File formats for Excel files

File formats for XML files

Lab Exercises

Work with objects

Create a data flow

Use the Query transform

Use target tables

Execute the job

Lab Exercises

Use descriptions and annotations

Validate and tracing jobs

Use View Data and the Interactive Debugger

Use auditing in data flows

Lab Exercises

Define built-in functions

Functions in expressions

Lookup function

Decode function

Variables and parameters

Data Services scripting language

Scripting custom functions

Lab Exercises

Map Operation transform

Validation transform

Merge transform

Case transform

SQL transform

Lab Exercises

Pivot transform

Hierarchy Flattening transform

Data Transfer transform

XML Pipeline transform

Lab Exercises

Error Handling

Recoverable work flows

Update data over time

Database native CDC mechanisms

Source-based CDC

Target Comparison

Lab Exercises

Fundamentals of DQ and Data Cleansing

Built in DQ Transformations

Data Validation

Name & Address cleansing

De duplication

Cleansing other data

Lab Exercises

Realtime jobs

SOAP Introduction

Web Services

Examples

Performance tuning of jobs

ETL best practices


Reviews

Amitesh

Enjoyed the learning and the instructor was of great help. Must say SAP BPC training was fruitful and will surely help me in my current job.

SAP BPC

5.0
2017-09-03T10:39:19+00:00

SAP BPC

Enjoyed the learning and the instructor was of great help. Must say SAP BPC training was fruitful and will surely help me in my current job.

Vivek

SAP GTS trainer was really good. He had the command on the subject and explained the concept well. I will surely recommend anyone who want to learn SAP GTS to gronysa.

SAP GTS

5.0
2017-09-04T06:51:45+00:00

SAP GTS

SAP GTS trainer was really good. He had the command on the subject and explained the concept well. I will surely recommend anyone who want to learn SAP GTS to gronysa.
5.0
2


Request for demo

Data Warehousing Courses

IBM Courses

Oracle Courses

Other Courses