/
Browse
/
Courses
/
Data Services - Platform and Transforms
/
Developing jobs and data flows
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 5 right to pass this unit.
1.
What is true about annotations?
Choose the correct answer.
An annotation is associated with the object diagram where it appears.
You enter an annotation by displaying an object properties dialog.
An annotation will appear in the Local Object Library list.
When a job, work flow, or data flow is imported or exported, and includes annotations, the associated annotations are NOT imported or exported.
2.
In the Query transform editor, where do you define the calculation expression for a new column ?
Choose the correct answer.
In the Output Schema
In the Mapping Tab
In the Where Tab
In the Input Schema
3.
A job is a schedulable object.
Choose the correct answer.
True
False
4.
When you connect objects in the workspace area you cannot disconnect them again.
Choose the correct answer.
True
False
5.
When a repository object is imported and exported, the description is also imported or exported.
Choose the correct answer.
True
False
6.
A job is the highest level of organization offered by SAP Data Services.
Choose the correct answer.
True
False