/ Browse / Courses / Data Services - Platform and Transforms / Using functions, scripts, and variables

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 5 right to pass this unit.

1.

What can be said about local variables?

There are two correct answers.

They are restricted to the job or work flow in which they are created.

They are included as part of the definition of the work flow or data flow, and so are portable between jobs.

Their value can be assigned through a script or at execution.

They are most commonly used to filter data in WHERE clauses.

2.

A custom function must have a return value and at least one input parameter.

Choose the correct answer.

True

False

3.

All functions can be called from custom functions or scripts.

Choose the correct answer.

True

False

4.

Where can you use scripts?

There are two correct answers.

In a job, before data flows, for initialization steps.

In a work flow, to check for file existence.

In a data flow, to assign values to variables.

In a project, to orchestrate job execution.

5.

A custom function can be used in a Query transform.

Choose the correct answer.

True

False

6.

Why would you use a substitution parameter?

Choose the correct answer.

To substitute a source value in a Query transform.

To define the name of a source file so it changes depending on the environment.

To define the connection parameter of a datastore so it changes depending on the environment.

To substitute a row with another in the target table.