SAP BODS
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.
SAP BODS Training is rendered by the best subject matter experts and the tutorials prepared by these expert industry allied tutors are made with latest industry updates.
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.
Classroom Training: An Instructor led training in our dynamic learning environment based in our office at West London. The classroom is fitted with all the essential amenities needed to ensure a comfortable training experience and with this training you will have an opportunity to build a Networking with other learners, share experiences and develop social interaction.
Online: Unlike most organisations our online based training is a tutor led training system similar to the classroom based training in every given aspect making it more convenient to the students from any location around the world and also cost effective.
Onsite: This training is specifically made for the Corporate clients who wish to train their staff in different technologies. The clients are given an opportunity where they can tailor the duration of course according to their requirements and the training can be delivered in house/ at your location of choice or online.
Customised one to one: A tailored course for students looking for undeterred attention from the tutor at all the times. The duration of course and contents of the course are specifically customised to suite the students requirements. In addition to it the timings of the trainings can also be customised based on the availability of both the tutor as well as the student.
4Weekends, 32 Hours, 10AM - 2PM
Functional or Technical Certification - £350 (excluding VAT)
Contractors can expect to earn between £300 and £500 per day depending on the experience. Permanent roles on average offer a salary of between £30 and £60k per annum, again depending on the experience required for the job. Permanent Lead roles requiring substantial experience can offer around the £100k per annum mark.
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.
Course Preview
- Definition of DW
- Methodology
- Dimensional Modelling
- DW Lifecycle
- DW Challenges
- Introduction of ETL
- Stage Area
- Rules of Business
- Performance
- Slowly Changing Dimensions
- Surrogate Keys
- Facts & Dimension Tables
- Different ETL Tools
- History
- Components
- Architecture
- Data Services Purpose
- Data Services architecture
- Define Data Services objects
- Data Services Designer interface
- Hierarchy of Object
- Jobs
- Workflows
- Data Flows
- Stores of Data
- File formats for flat files
- File formats for Excel files
- File formats for XML files
- Lab Exercises
- Creation of repository
- Job Server Setting
- Setup for real-time operation
- Setting multiple data stores
- Starting the Job servers
- Lab Exercises
- Work with objects
- Creation of data flow
- Use the Query transform
- Use target tables
- Executing the job
- Lab Exercises
- Use descriptions & annotations
- Validate & tracing jobs
- Use View Data & the Interactive Debugger
- Use auditing in data flows
- Lab Exercises
- Defining the built-in functions
- Functions in expression
- Lookup function
- Decode function
- Variables & parameters
- Data Service scripting language
- Scripting the custom function
- 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 mechanism
- Source based CDC
- Target Comparison
- Lab Exercises
- Fundamentals of DQ & Data Cleansing
- Built in DQ Transformation
- Data Validation
- Name & Address cleansing
- Deduplication
- Cleansing other data
- Lab Exercises
- SOAP Introduction
- Web Services
- Creating the datastores for SAP databases
- Accessing the SAP data
- Running ABAP programs
- R/3 Data flows
