· SAP HR

Oracle Oracle Apps Modules

Datastage, Microstratogy. Spirit Soft is to enable world-class companies to increase productivity and performance through their people. Our In-Company training solution is all about your organization – we can work with you to identify your individual and companywide training needs to deliver a course that meets your needs.

SAP Business objects data services is an ETL tool used for data marts, ODS system, etc. Ensure complete and accurate information with enterprise class solution for data integration and data quality. User-define standards are published in a custom Cleansing Package which is usable by Data Services through the Data Cleanse transform. SAP BODS Certification Online Training enhances to move data from any applications into SAP Business suite deployment and master the data management.

SAP BODS Certification Training Overview

Spiritsofts main objective is to providing SAP BODS 4.x training to enhance administration, performance tuning and metadata management. Understand the requirements of learner and sessions are designed to module accordingly by 11+ years of real time experienced IT Professionals with hands-on.

SAP BODS Online Training Course Content

Introduction to BODS

Place of BODS among modern DI software package

Competitive advantage of BODS

ETL and ELT approach

How both approaches can be combined in one tool

Data Services components and architecture

Basics of BODS

Concepts of Job, Workflow and Data Flow

Concepts of Datastore

Creating basic Batch Job

Transforms overview

Data profiling and Query Transform

Analyzing data sources

Joining data from multiple sources

Basic transformations and build-in functions

Aggregating data in BODS

Lookup

Working with Files

Defining file formats for file data source

Working with XML files(XSD,DTD)

COBAL COPY BOOKS

File Formats as Source and as Targets

Platform Transforms Overview

Case and Merge transforms

SQL transform

Validation transform

Row Generation

Map Operation

Combining Validation and Auditing – best practices

Data Integrator Transforms

Working with hierarchical data

Hierarchy Flattening transform

Merging data

Table Comparison transform

Other ways of merging data for RDBMS datastores

Slowly changing dimension support in BODS

History preserving transform

Using built-in functions

Use date and time functions and the date generation transform to build a dimension table

Use the lookup functions to look up status in a table

Use match pattern functions to compare input strings to patterns

Use database type functions to return information on data sources

Metadata Management

Local and Central repositories

Working in a group

Propagating Job from development to staging and production environment – best practices