/ Browse / Courses / Data Services - Platform and Transforms / Optimizing Performance

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 min
Using Source-Based Changed Data Capture (CDC)7 min
Using Target-Based Changed Data Capture (CDC)11 min
Quiz

Designing advanced ETL scenarios using SAP Data Services Integrator transforms

Describing SAP Data Services Integrator transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 min
Using Source-Based Changed Data Capture (CDC)7 min
Using Target-Based Changed Data Capture (CDC)11 min
Quiz

Designing advanced ETL scenarios using SAP Data Services Integrator transforms

Describing SAP Data Services Integrator transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

1.

Which one of these statements about push-down operations is true?

Choose the correct answer.

Full push-down operations are possible when the source and target tables are from different datastores.

Data Services performs a partial push-down with a SELECT statement to the source database.

Data Services can push all transform operations to the database.

You can push built–in functions and transforms to the source database.

2.

Which settings can improve performance and can be applied to joins?

There are three correct answers.

Caching

Ranking

Process Slicing

Bulk Loading

Automatic Data Transfer

3.

A Data Transfer transform allows a data flow to push down resource-consuming operations to the database server.

Choose the correct answer.

True

False