Tasks

Back Next

Data integration tasks

A data integration task is a process that you configure to analyze, extract, transform, and load data. You can run individual tasks manually or set tasks to run on a schedule.

You can use the following tasks to integrate data:

Mapping

. Use to process data based on the data flow logic defined in a mapping

or Visio template

Dynamic mapping

. Use to run multiple jobs with different parameters based on the data flow logic defined in the same mapping.

Synchronization

. Use to load data and integrate applications, databases, and files. Includes add-on functionality such as mapplets.

Data transfer

. Use to move data from a source to a target. Optionally, sort and filter data before loading it to the target.

Replication

. Use to replicate data from Salesforce or database sources to database or file targets. You might replicate data to archive the data, perform offline reporting, or consolidate and manage data.

Masking

. Use to replace source data in sensitive columns with realistic test data for non-production environments.

Masking

rules define the logic to replace the sensitive data. Assign

masking

rules to the columns you need to mask.

PowerCenter. Use to import a PowerCenter workflow and run it as a

Data Integration

PowerCenter task.

When you create a task,

Data Integration

walks you through the required steps. The options and properties that display depend on the task type