Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Supported transformations and mapping objects

Supported transformations and mapping objects

The mapping objects in a workflow must be supported by
Data Integration
.
A mapping can include the following source and target types:
  • Flat file
  • FTP/SFTP
  • Database
  • Salesforce
  • SAP
  • Web service
  • Most add-on connectors
To find out if the add-on connector you use supports PowerCenter tasks, see the help for the appropriate
Data Integration
connector.
A mapping can include the following transformations:
  • Aggregator transformation
  • Data Masking transformation
  • Expression transformation
  • Filter transformation
  • HTTP transformation
  • Java transformation
  • Joiner transformation
  • Lookup transformation
  • Normalizer transformation
  • Router transformation
  • Salesforce Lookup transformation
  • Salesforce Picklist transformation
  • Salesforce Merge transformation
  • SAP IDOC Interpreter transformation
  • SAP IDOC Prepare transformation
  • Sequence Generator transformation
  • Sorter transformation
  • Stored Procedure transformation
  • Transaction Control transformation
  • Union transformation
  • Update Strategy transformation
  • Web Services Consumer transformation
  • XML Parser transformation with file or database sources
  • XML Generator transformation with file or database sources
If the workflow contains transformations or mapping objects other than the objects listed above, the workflow upload to
Data Integration
might fail.

0 COMMENTS

We’d like to hear from you!