/
Browse
/
Courses
/
Data Services - Platform and Transforms
/
Troubleshooting batch jobs
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 4 right to pass this unit.
1.
Select the correct statements about job validation.
There are two correct answers.
The Validate All option will always validate all the objects present in the Job.
You cannot validate jobs automatically before execution.
The Validate Current option triggered on a job will not validate the objects in the data flow.
A partial validation can be performed on a data flow before you have finished designing the job.
2.
If you have already opened two view data panes, what will happen when you select a third window to be opened?
Choose the correct answer.
You are prompted to choose which window to close.
A third window opens besides the two existing ones.
An error occurs.
The first window to be opened is closed.
3.
Which of the following sentences are true about Job Traces ?
There are two correct answers.
Job traces have to be set before each job execution.
Trace Logs can be used to determine where an execution failed.
Monitor Logs can be used to determine which error caused the job to fail.
Some traces write a statement for each record processed by a transform.
4.
The interactive debugger places filters and breakpoints on lines in a data flow diagram.
Choose the correct answer.
True
False
5.
View data allows you to display table and file data from the Local Object Library.
Choose the correct answer.
True
False