/
Browse
/
Courses
/
Data Services - Platform and Transforms
/
Handling errors and recovering from failure
Explaining SAP Data Services
Introducing SAP Data Services solution
7 min
Describing the object model
10 min
Quiz
Accessing data
Connecting to databases or applications using Datastores
10 min
Accessing files using Flat File Formats
10 min
Quiz
Developing jobs and data flows
Creating Batch Jobs
2 min
Creating Data Flows
27 min
Documenting Jobs
5 min
Quiz
Troubleshooting batch jobs
Validating Jobs
5 min
Testing Jobs
10 min
Debugging Data Flows
7 min
Quiz
Using functions, scripts, and variables
Computing data using built-in functions
5 min
Designing independent reusable objects with variables and parameters
10 min
Initializing variables using scripts
10 min
Reusing logic with a custom function
2 min
Using jobs in different system configurations
5 min
Quiz
Querying data with Platform transforms
Building new data sets with the Query transform
2 min
Choosing between lookup function and join operation
5 min
Using the SQL Transform
3 min
Quiz
Splitting and combining data with Platform transforms
Splitting data with the Case transform
2 min
Splitting data with the Validation Transform
10 min
Combining data with the Merge transform
3 min
Quiz
Handling errors and recovering from failure
Auditing dataflows
10 min
Setting up error handling
20 min
Using automatic recovery mode
5 min
Quiz
Updating data
Bringing changes to the target table
17 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 transforms
8 min
Converting columns to rows using the Pivot transform
3 min
Quiz
Optimizing Performance
Optimizing data flows using the Data Transfer transform
8 min
Setting options to improve performance
24 min
Quiz
Explaining SAP Data Services
Introducing SAP Data Services solution
7 min
Describing the object model
10 min
Quiz
Accessing data
Connecting to databases or applications using Datastores
10 min
Accessing files using Flat File Formats
10 min
Quiz
Developing jobs and data flows
Creating Batch Jobs
2 min
Creating Data Flows
27 min
Documenting Jobs
5 min
Quiz
Troubleshooting batch jobs
Validating Jobs
5 min
Testing Jobs
10 min
Debugging Data Flows
7 min
Quiz
Using functions, scripts, and variables
Computing data using built-in functions
5 min
Designing independent reusable objects with variables and parameters
10 min
Initializing variables using scripts
10 min
Reusing logic with a custom function
2 min
Using jobs in different system configurations
5 min
Quiz
Querying data with Platform transforms
Building new data sets with the Query transform
2 min
Choosing between lookup function and join operation
5 min
Using the SQL Transform
3 min
Quiz
Splitting and combining data with Platform transforms
Splitting data with the Case transform
2 min
Splitting data with the Validation Transform
10 min
Combining data with the Merge transform
3 min
Quiz
Handling errors and recovering from failure
Auditing dataflows
10 min
Setting up error handling
20 min
Using automatic recovery mode
5 min
Quiz
Updating data
Bringing changes to the target table
17 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 transforms
8 min
Converting columns to rows using the Pivot transform
3 min
Quiz
Optimizing Performance
Optimizing data flows using the Data Transfer transform
8 min
Setting options to improve performance
24 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 of the following do you use to recover from partially loaded tables?
Choose the correct answer.
The standard RDBMS services.
Automatic Recovery.
Validation transform.
Exceptions.
2.
The auto-correct load checks the target table for existing rows before adding new rows to the table.
Choose the correct answer.
True
False
3.
Select the correct sequence for auditing data flows:
Choose the correct answer.
Add audit points, create audit rules, enable auditing, add audit trace.
Enable auditing, add audit points, create audit rules, add audit trace.
Enable auditing, create audit rules, add audit points, add audit trace.
Create audit rules, add audit points, enable auditing, add audit trace.
4.
In recovery mode, Data Services does not execute the steps that generated an exception but completed successfully, such as those in a try/catch block.
Choose the correct answer.
True
False