SAP BODS Online Training
0 STUDENTS ENROLLED
SAP BODS Course Content :
1. DW Concepts
- Definition
- Methodologies
- Dimensional Modeling
- DW Lifecycle
- DW Challenges
2. ETL Overview
- ETL introduction
- Staging Area
- Business Rules
- Performance
- Slowly Changing Dimensions
- Surrogate Keys
- Facts and Dimension Tables
- Different ETL Tools
3. Business Objects Overview
- History
- Components
- Architecture
4. Data Services
- Purpose of Data Services
- Data Services architecture
- Define Data Services objectsData Services Designer interface
5. Data Services Objects
- Object Hierarchy
- Workflows
- Data Flows
6. Source and Target Metadata
- Data Stores
- File formats for flat files
- File formats for Excel files
- File formats for XML files
- Lab Exercises
7. Environment setup
- Creating repository
- Setting Job Server
- Setup for realtime operation
- Setting multiple datastores
- Starting Job servers
- Lab Exercises
8. Batch Jobs
- Work with objects
- Create a data flow
- Use the Query transform
- Use target tables
- Execute the job
- Lab Exercises
9. Troubleshooting Jobs
- Use descriptions and annotations
- Validate and tracing jobs
- Use View Data and the Interactive Debugger
- Use auditing in data flows
- Lab Exercises
10.Functions, Scripts and Variables
- Define built-in functions
- Functions in expressions
- Lookup functionDecode function
- Variables and parameters
- Data Services scripting language
- Scripting custom functions
- Lab Exercises
11. Important Transforms
- Map Operation transform
- Validation transform
- Merge transform
- Case transform
- SQL transform
- Lab Exercises
12. Other Transforms
- Pivot transform
- Hierarchy Flattening transform
- Data Transfer transform
- XML Pipeline transform
- Lab Exercises
13. Error Handling
- Error Handling
- Recoverable work flows
14. Change Data Capture
- Update data over time
- Database native CDC mechanisms
- Source-based CDC
- Target Comparison
- Lab Exercises
15. Data quality Overview
- Fundamentals of DQ and Data Cleansing
- Built in DQ Transformations
- Data Validation
- Name & Address cleansing
- De duplication
- Cleansing other data
- Lab Exercises
- Web-Services and Real-Time IntegrationReal Time Jobs
- SOAP Introduction
- Web Services
16. SAP Integration
- Creating datastores for SAP databases
- Accessing SAP data
- Running ABAP programs
- R/3 Data flows
Course Reviews
No Reviews found for this course.
Write a Review