Data Services Fundamentals XI3.0

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. 

Who should attend?

This course is designed for individuals responsible for implementing, administering and managing data quality projects.

Delegates will be able to

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

Pre-requisites

To be successful, delegates who attend this course should have experience with

• Data warehousing and ETL concepts.
• My SQL and SQL language.
• Functions, elementary procedural programming, and flow-of-control statements such as If-Then-Else and While Loop statements.
• Data Warehouse Architecture and Modelling.

Additional education

If you want to increase your skiil level and knowledge, these courses are recommended,

• SAP BusinessObjects - Data Integrator Transforms XI 3.0/3.1
• SAP BusinessObjects - Data Quality Core Concepts XI 3.0/3.1
• Data Warehousing - Data Warehouse Design

Topics covered

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