SAP BusinessObjects: Data Services Fundamentals XI3.0

Overview

Data Services Fundamentals XI3.0 enables you to integrate disparate data sources to deliver more timely and accurate data that end users in an organization can trust. In this two-day course, delegates will learn how to create, execute, and troubleshooting batch jobs, using functions, scripts and transforms to change the structure and format of data.

Prerequisites

This course is designed for individuals responsible for implementing, administering, and managing data integration projects. To be successful, delegates who attend this course should have experience with the following:
• Knowledge of data warehousing and ETL concepts
• Experience with My SQL and SQL language
• Experience using functions, elementary procedural programming, and flow-of-control statements such as If-Then-Else and While Loop statements
• Data Warehouse Fundamentals
• Data Warehouse Architecture and Modelling
• Data staging and data quality issues

Delegates will be able to:

• Create, execute, and troubleshoot batch jobs using functions, scripts and transforms.
• Change the structure and format of data, and handle errors efficiently.

Outline

Describing Data Services
• Describe the purpose of Data Services
• Describe Data Services architecture
• Define Data Services objects
• Use the Data Services Designer interface

Defining source and target metadata
• Use data stores
• Use data store and system configurations
• Define file formats for flat files
• Define file formats for Excel files
• Define file formats for XML files

Creating batch jobs
• Work with objects
• Create a data flow
• Use the Query transform
• Use target tables
• Execute the job

Trouble shooting batch jobs
• Use descriptions and annotations
• Validate and tracing jobs
• Use 'view data' and the 'interactive debugger'
• Use auditing in data flows

Using functions, scripts, and variables
• Define built- in functions
• Use functions in expressions
• Use the look up function
• Use the decode function
• Use variables and parameters
• Use Data Services scripting language
• Script a custom function

Using Platform Transforms
• Describe Platform Transforms
• Use the Map Operation transform
• Use the Validation transform
• Use the Merge transform
• Use the Case transform
• Use the SQL transform

Setting up error handling
• Set up recoverable workflows
• Topics covered / modules / course agenda

QA reserves the right to improve the specification and format of its courses for the benefit of its customers without notice to the customer.