Course Content

 BODS Course Content

TOPICS:

Lesson 1. Dataware housing concepts

  • Describe dimensional modeling

Lesson 2. Understanding Data Services

  • Describe components, management tools, and the development process
  • Explain object relationship

Lesson 3. Defining source and target metadata

  • Create a database data store and import metadata
  • Create a new file format and handle errors in file formats

Lesson 4. Validating, tracing, and debugging jobs

  • Use description and annotations
  • Validate and trace jobs
  • Use view data and the Interactive Debugger

Lesson 5. Creating a batch job

  • Create a project, job, work flow, and data flow
  • Use the query transform in a data flow
  • Use template tables

Lesson 6. Using built-in transforms and nested data

  • Use the case, merge, and validation transforms
  • Use the Pivot, reverse Pivot
  • Hierarchy flattening

Lesson 7. Using built-in functions

  • Use date and time functions and the date generation transform to build a dimension table
  • Use the lookup functions to look up status in a table
  • Use match pattern functions to compare input strings to patterns
  • Use database type functions to return information on data sources

Lesson 8. Using Data Services Scripting Language and Variables

  • Explain differences between global and local variables
  • Create global variables and custom functions
  • Use strings and variables in Data Integrator scripting language

Lesson 9. Capturing Changes in Data

  • Use Change Data Capture (CDC) with time-stamped sources
  • Source CDC concept and working
  • Target CDC concept and working
  • Working with Slowly changing Dimentions(type1,2,3)
  • Create an initial and delta load job
  • Use history preserving transform

Lesson 10.Handling errors and auditing

  • Recover a failed job
  • Create a manual, recoverable work flow
  • Define audit points, rules and actions on failures

Lesson 11. Supporting a multi-user environment

  • Describe terminology and respository types in a multi-user
  • environmentCreate and activate the central repository

Lesson 12. Migrating Projects

  • Work with projects in the central repository
  • Creation of Profile Repository
  • Understand Profiling

Lesson 13. Using the Administrator

  • Execute, schedule, and monitor batch jobs
  • Understand architecture, load balance index, and job execution in server groups

Lesson 14. Profiling Data

  • Set up the Data Profiler and users
  • Submit a profiling task
  • Monitor profiling tasks in the Administrator

Lesson 15. Managing Metadata

  • Import and export metadata
  • Use Metadata Reports

Lesson 16. Data Quality Management

Lesson17.SAP Integration

  • Data extraction from ECC system to File, DatabaseTables
  • SAP Extraction and loading into SAP BI
  • ABAP WorkFlows
  • Extracting data from SAP BI using Openhub Services and Data services as 3rd party system.
  • Working with SAP Function Modules
  • Extractions through BW DataSources.
  • Configuration and RFC Maintainance

Lesson18.SAP Integration

  • Integration of SAP HANA with BODS
  • Configuring the SAP HANA Datastore
  • Loading into SAP HANA(ECC,Flatfiles,Db tables)
  • Working with the SAP Dataservices Workbench

Course Duration: 30 hours

Home page…..

Sap bods online training © 2015 Frontier Theme