[wpcol_1third id=”” class=”” style=””]

youtube

 

>>   SAP BODS

>>   SAP BI

>>   SAP FICO

>>   SAP CO

>>   SAP CRM

>>   SAP HR HCM

>>   SAP SD

>>   SAP PP

>>   SAP PS

>>   SAP PM

>>   SAP MM

>>  SAP WM

>>   SAP QM

[/wpcol_1third] [wpcol_2third_end id=”” class=”” style=””]

SAP BODS

SAP Business Objects Dataservices

Duration : 30 Hrs

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

[/wpcol_2third_end]

Leave a comment

Your email address will not be published. Required fields are marked *