SAP BODS

SAP BODS Course Content

INTRODUCTION

  • 1. Overview of ERP
  • 2. Overview of DW
  • 3. Overview of ETL
  • 4. Overview of SAP BODS (SAP DS)

SAP BODS (SAP DS)

  • 1. SAP Data Services Designer
  • 2. Data Services Objects in Designer
  • 3. SAP BODS Architecture and its Components

SAP BODS System Setup

  • 1. Database Creation
  • 2. Repository Creation(Local, Central, Profiler)
  • 3. Repository Registration in CMC
  • 4. Job Server Creation

SAP BODS Metadata Reporting Tool and its Modules

  • 1. Data Services Management Console(DSMC)
    • a. Administrator
    • b. Auto Documentation
    • c. Data Validation
    • d. Impact and Lineage Analysis
    • e. Operational Dashboard
    • f. Data Quality Reports

SAP BODS Datastores

  • 1. Database Datastores(MS Sql Server ; SAP HANA)
  • 2. Application Datastores(SAP ECC)
  • 3. Memory/ Linked/Adapter Datastores

SAP BODS File Format

  • 1. Extraction of Data from Flat File(CSV; TXT)
  • 2. Extraction of Data from Excel Workbook
  • 3. Extraction of Data from XML file

Data Flow and Work Flow

  • 1. Creation of Work Flow
  • 2. Creation of Data Flow
  • 3. Replication of Data Flow
  • 4. Nested Data Flow

Batch Job Creation and Execution

  • 1. Manual Execution
  • 2. Execution through Scheduling
  • 3. Execution Properties

Troubleshooting, Debugging and Exception Handling

  • 1. Interactive Debugging
  • 2. Filter Option
  • 3. Validating and Tracing Jobs
  • 4. Auditing

Functions, Scripts, Variables

  • 1. Built-In Functions(lookup_ext()
  • 2. Aggregate Functions
  • 3. Creation of custom Functions
  • 4. Use of Variables, Parameters, Scripts

SAP BODS Platform Transform

  • 1. Case
  • 2. Merge
  • 3. Validation
  • 4. SQL
  • 5. Map_Operation
  • 6. Row_Generation
  • 7. XML_Map

SAP BODS Data Integrator Transform

  • 1. Data Transfer
  • 2. Date_Generation
  • 3. Effective_Date
  • 4. Hierarchy_Flattening
  • 5. History_Preserving
  • 6. Key_Generation
  • 7. Pivot
  • 8. Reverse_Pivot
  • 9. Table_Comparison
  • 10. XML_Pipeline

SAP BODS Data Quality Transform

  • 1. Global_Address_Cleanse
  • 2. Data Cleanse
  • 3. Match

Changes in Data(CDC)

  • 1. Source-Based Changed Data Capture(SCDC)
  • 2. Target-Based Changed Data Capture(TCDC)

SAP BODS Recovery Mechanism

  • 1. Recovery Mechanism
  • 2. Describing Levels of Data Recovery Strategies
  • 3. Recovery Units
  • 4. Recovery Mode
  • 5. Automatic Recovery

SAP BODS Multi-User Environment

  • 1. Central Repository
  • 2. Check-In and Check-Out from Central Repository
  • 3. Exporting Repository
  • 4. Exporting Selected Objects

SAP BODS Performance Optimization

  • 1. Distributed Data Flow Execution
  • 2. Full Push Down/ Partial Push Down/No Push Down
  • 3. Performance Optimization Parameters

Real Time Project (Sales Data Warehouse Creation)

Mock Tests

Mock Interview(One on One)

SAP BODS Interview Questions

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SAP BODS

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content