SAP BODS
SAP BUSINESS OBJECTS DATA SERVICES
4.0 Role Based Training Program
A way to deliver Role Specific Training
Data warehousing
concepts
• Describe
dimensional modeling
Understanding Data
Integrator
• Describe
components, management tools, and the development process
• Explain
object relationship
Defining source and
target metadata
• Create a
database datastore and import metadata
• Create a
new file format and handle errors in file formats
Validating, tracing,
and debugging jobs
• Use
description and annotations
• Validate
and trace jobs
• Use view
data and the Interactive Debugger
Creating a batch job
• Create a
project, job, work flow, and data flow
• Use the
query transform in a data flow
• Use
template tables
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
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
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
Capturing Changes in
Data
• Use
Change Data Capture (CDC) with time stamped sources
• Create an
initial and delta load job
• Use
history preserving transform
Handling errors and
auditing
• Recover a
failed job
• Create a
manual, recoverable work flow
• Define Audi
points, rules and actions on failures
Supporting a multi
user environment
• Describe
terminology and repository types in a multi user environment
• Create
and activate the central repository
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
Profiling Data
• Set up
the Data Profiler and users
• Submit a
profiling task
• Monitor
profiling tasks in the Administrator
Managing metadata
• Import
and export metadata
• Use
metadata reports
Contact Sreeram: 091-9916083157 or 001-210-399-8414
sap.sreeram@gmail.com
