Dubai Forums Dubai Classifieds Services in Dubai

SAP BODS ONLINE Course Content

DW Concepts
• Definition
• Methodologies
• Dimensional Modeling
• DW Lifecycle
• DW Challenges
ETL Overview
• ETL introduction
• Staging Area
• Business Rules
• Performance
• Slowly Changing Dimensions
• Surrogate Keys
• Facts and Dimension Tables
• Different ETL Tools
Business Objects Overview
• History
• Components
• Architecture
Data Services
• Purpose of Data Services
• Data Services architecture
• Define Data Services objects
• Data Services Designer interface
Data Services Objects
• Object Hierarchy
• Jobs
• Workflows
• Data Flows
Source and Target Metadata
• 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
Batch Jobs
• Work with objects
• Create a data flow
• Use the Query transform
• Use target tables
• Execute the job
• Lab Exercises
Troubleshooting Jobs
• Use descriptions and annotations
• Validate and tracing jobs
• Use View Data and the Interactive Debugger
• Use auditing in data flows
• Lab Exercises
Functions, Scripts and Variables
• Define built-in functions
• Functions in expressions
• Lookup function
• Decode function
• Variables and parameters
• Data Services scripting language
• Scripting custom functions
• 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 mechanisms
• Source-based CDC
• Target Comparison
• Lab Exercises
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 Integration
• Real Time Jobs
• SOAP Introduction
• Web Services
SAP Integration
• Creating datastores for SAP databases
• Accessing SAP data
• Running ABAP programs
• R/3 Data flows

CONTACT ADDRESS:-
COURSE NAME: SAP BODS ONLINE TRAINING
Contact Number: 
    USA: +1-678-693-3475
INDIA: +91-9052666558, 9052666558,
Email: info@magnifictraining.com,
Web: http://www.magnifictraining.com/sap-bods-online-training/