/
Browse
/
Courses
/
Data Services - Platform and Transforms
/
Updating data
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 transforms manage rows with Insert, Update or Delete operation codes?
There are two correct answers.
Map Operation
History Preserving
Query
Validation
2.
Select the correct sequence for implementing a Target Based Changed Data Capture data flow preserving history.
Choose the correct answer.
Table Comparison, History Preserving, Key Generation.
History Preserving, Table Comparison, Key Generation.
Table Comparison, Key Generation, History Preserving.
3.
Which solutions can be used to implement a source based Changed Data Capture?
There are two correct answers.
Table Comparison
Timestamps
Change Log
History Preserving