/
Browse
/
Courses
/
Data Services - Platform and Transforms
/
Splitting and combining data with Platform transforms
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 these statements about Case transforms are correct?
There are two correct answers.
The Case transform supports separating data from a source into multiple targets based on branch logic.
The Case transform allows for the selection of only a subset of the source data.
Multiple data flow sources are allowed as a data input for the Case transform.
The connections between the Case transform and objects used for a particular case are not labeled.
2.
Select all sentences that apply to the Validation transform:
There are three correct answers.
It qualifies source data sets based on rules.
It is used to split your data into different tables.
It allows several rules per column.
It can substitute the value in the Failschema.
It can collect statistics for use in reports of the Management Console.
3.
The Merge transform combines incoming data sets with the same schema structure to produce a single output data set with the same schema as the input data sets.
Choose the correct answer.
True
False