SAP BODS training is an ETL tool used for datamarts, 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 useable by Data Services through the Data Cleanse transform. SAP BODS Training enhance to move data from any applications into SAP business suite deployment and master the data management.
By the end of this training you will:
– Acquire the relevant knowledge required to clear the SAP certification exam.
– Understand the core concepts of SAP’s BODS module.
– Be able to apply the knowledge learned to progress in your career as an associate level SAP BODS consultant.
Essential
None
Recommended/Additional
A good bachelor’s degree in any field would be an advantage. Awareness to database technologies and basic software knowledge is advantageous but not a must.
32 Hours
Although there is no guarantee of a job on course completion, we are almost certain that you should be able to find a suitable position within a few weeks after successful completion of the course.
Concepts of DW
- Definition of DW
- Methodology
- Dimensional Modelling
- DW Lifecycle
- DW Challenges
Overview of ETL
- Introduction of ETL
- Stage Area
- Rules of Business
- Performance
- Slowly Changing Dimensions
- Surrogate Keys
- Facts & Dimension Tables
- Different ETL Tools
Overview of Business objects
- History
- Components
- Architecture
Data Services
- Data Services Purpose
- Data Services architecture
- Define Data Services objects
- Data Services Designer interface
Data Services objects
- Hierarchy of Object
- Jobs
- Workflows
- Data Flows
Source and Target Metadata
- Stores of Data
- File formats for flat files
- File formats for Excel files
- File formats for XML files
- Lab Exercises
Environment Setup
- Creation of repository
- Job Server Setting
- Setup for real-time operation
- Setting multiple data stores
- Starting the Job servers
- Lab Exercises
Batch Jobs
- Work with objects
- Creation of data flow
- Use the Query transform
- Use target tables
- Executing the job
- Lab Exercises
Troubleshooting Jobs
- Use descriptions & annotations
- Validate & tracing jobs
- Use View Data & the Interactive Debugger
- Use auditing in data flows
- Lab Exercises
Functions, Scripts & Variables
- Defining the built-in functions
- Functions in expression
- Lookup function
- Decode function
- Variables & parameters
- Data Service scripting language
- Scripting the custom function
- Lab Exercises
Important Transforms
- Map Operation transform
- Validation transform
- Merge transform
- Case transform
- SQL transform
- Lab Exercises
Other Transforms
- Pivot transform
- Hierarchy Flattening transform
- Data Transfer transform
- XML Pipeline transform
- Lab Exercises
Error Handling
- Error Handling
- Recoverable work flows
Change Data capture
- Update data over time
- Database native CDC mechanism
- Source based CDC
- Target Comparison
- Lab Exercises
Overview of Data Quality
- Fundamentals of DQ & Data Cleansing
- Built in DQ Transformation
- Data Validation
- Name & Address cleansing
- Deduplication
- Cleansing other data
- Lab Exercises
Webservices and Realtime Integration
- SOAP Introduction
- Web Services
SAP Integration
- Creating the datastores for SAP databases
- Accessing the SAP data
- Running ABAP programs
- R/3 Data flows
Leave a Reply