SAP BODS Training Contents

1.Data warehousing concepts
•Describe dimensional modeling

2.Understanding Data Integrator

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

3.Defining source and target metadata
•Create a database datastore and import metadata
•Create a new file format and handle errors in file formats

4.Validating, tracing, and debugging jobs
•Use description and annotations
•Validate and trace jobs
•Use view data and the Interactive Debugger

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

6.Using built-in transforms and nested data
•Use the case, merge, and validation transforms
•Import metadata from XML documents
•Use the XML pipeline in a data flow

7.Using built-in functions
•Use data 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

8.Using Data Integrator 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

9.Capturing Changes in Data
•Use Change Data Capture (CDC) with time stamped sources
•Create an initial and delta load job
•Use history preserving transform

10.Handling errors and auditing
•Recover a failed job
•Create a manual, recoverable work flow
•Define Audi points, rules and actions on failures

11.Supporting a multi user environment
•Describe terminology and repository types in a multi user environment
•Create and activate the central repository

12.Migrating Projects
•Work with projects in the central repository
•Implement and modify group permissions

13.Using the administrator
•Add a repository and user roles
•Set the job status interval and log retention period
•Execute, schedule, and monitor batch jobs
•Understand architecture and job execution in server groups

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

15.Managing metadata
•Import and export metadata
•Use metadata reports