/ Browse / Courses / Data Services - Platform and Transforms / Querying data with Platform transforms

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 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 transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Explaining SAP Data Services

Introducing SAP Data Services solution7 min
Describing the object model10 min
Quiz

Accessing data

Connecting to databases or applications using Datastores10 min
Accessing files using Flat File Formats10 min
Quiz

Developing jobs and data flows

Creating Batch Jobs2 min
Creating Data Flows27 min
Documenting Jobs5 min
Quiz

Troubleshooting batch jobs

Validating Jobs5 min
Testing Jobs10 min
Debugging Data Flows7 min
Quiz

Using functions, scripts, and variables

Computing data using built-in functions5 min
Designing independent reusable objects with variables and parameters10 min
Initializing variables using scripts10 min
Reusing logic with a custom function2 min
Using jobs in different system configurations5 min
Quiz

Querying data with Platform transforms

Building new data sets with the Query transform2 min
Choosing between lookup function and join operation5 min
Using the SQL Transform3 min
Quiz

Splitting and combining data with Platform transforms

Splitting data with the Case transform2 min
Splitting data with the Validation Transform10 min
Combining data with the Merge transform3 min
Quiz

Handling errors and recovering from failure

Auditing dataflows10 min
Setting up error handling20 min
Using automatic recovery mode5 min
Quiz

Updating data

Bringing changes to the target table17 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 transforms8 min
Converting columns to rows using the Pivot transform3 min
Quiz

Optimizing Performance

Optimizing data flows using the Data Transfer transform8 min
Setting options to improve performance24 min
Quiz

Knowledge quiz

It's time to put what you've learned to the test, get 3 right to pass this unit.

1.

lookup_ext has more functionality than lookup.

Choose the correct answer.

True

False

2.

You must add a source of type Datastore in your data flow in order to use the SQL transform.

Choose the correct answer.

True

False

3.

what can you do with lookup functions that you cannot do with a join operation?

There are two correct answers.

You can return only one value when there are several matches.

You can define a default value if no match is found.

You can combine table data with file data.

You can use template tables.

4.

You load a new template table using a Query transform. Why would you use an aggregate function?

Choose the correct answer.

To calculate a new column concatenating several values for each row of the source data set.

To add to the source rows a new row with total values for the whole data set.

To add to the source rows a new row with total values for each group defined in the GROUP BY tab.

To create a target data set with only total values.