Select this option to create a

data transfer

task.

A

data transfer

task uses a step-by-step, wizard-based interface to transfer data from your source to your target. For example, you might create a

data transfer

task to transfer data from an on-premises database to your cloud data warehouse.

If you wish, you can augment the source data with data from a lookup source and also sort and filter the data before loading it to the target.

Select this option to create a mapping using the Mapping Designer.

Create a mapping when you need flexibility in your sources, targets, and transformation options. A mapping can read and write to a wide variety of heterogeneous data sources. It also offers a large variety of data transformation options.

When you run a mapping ,

Data Integration

processes the transformation logic. However, you can choose to push some or all the transformation logic to the source, to the target, or both.

Select this option to create a mapping in SQL ELT mode using the Mapping Designer.

Create a mapping in SQL ELT mode when your source and target are in the same cloud ecosystem and you want to perform the data transformation entirely within the cloud ecosystem. For example, you want to read data from your Snowflake cloud data warehouse or data lake, load it to your Snowflake cloud data warehouse, and perform all of the data transformation within Snowflake.

When you run a mapping in SQL ELT mode,

Data Integration

translates the transformation logic into ecosystem-specific SQL statements and commands that run in the underlying cloud data warehouse.