Mapping Tasks with Microsoft Azure SQL Data Warehouse V2
Mapping
Tasks with Microsoft Azure SQL Data Warehouse V2
Use a mapping to define data flow logic that is not available in
synchronization
tasks, such as specific ordering of logic or joining sources from different systems. Use the
Data Integration
Mapping Designer to configure mappings.
When you configure a mapping to describe the flow of data from source and target, you can also add transformations to transform data. A transformation includes field rules to define incoming fields. Links visually represent how data moves through the data flow.
After you create a mapping, you can run the mapping or you can deploy the mapping in a
mapping
task. The
mapping
task allows you to process data based on the data flow logic defined in a mapping.
Use the
Mapping
task wizard to create a
mapping
task. When you create a
mapping
task, you select the mapping for the task to use.
If you configured parameters, which are placeholders for information, in a mapping, you can define the parameters in the
mapping
task. Defining parameters provides additional flexibility and allows you to use the same mapping in multiple
mapping
tasks. For example, you can use a parameter for a source connection in a mapping, and then define the source connection when you configure the
mapping
task.
When you create a
mapping
task, you can associate the task with a schedule to run it at specified times or on regular intervals. Or, you can run it manually. You can also configure advanced session properties. You can monitor tasks that are currently running in the activity monitor and view details about completed tasks in the activity log.