PowerCenter XML Files for Mapplets
To use a mapplet in Informatica Cloud, you upload a PowerCenter XML file that defines a PowerCenter mapplet.
Consider the following rules when you use a PowerCenter XML file to create a Informatica Cloud mapplet:
- •If the mapplet includes a transformation that uses a connection, then the PowerCenter XML file must contain only one workflow, one Session task, one mapping, and one mapplet.
If the mapplet doesn't include a transformation that uses a connection, then the PowerCenter XML file must include one mapplet. The workflow, Session task, and mapping are optional.
- •The session can use any type of connection.
- •You do not have to map all source and target fields in the PowerCenter mapping.
- •The PowerCenter mapplet can contain the following supported transformations:
- - Aggregator transformation
- - Expression transformation
- - Filter transformation
- - HTTP transformation
- - Lookup transformation
- - Salesforce Lookup transformation (multiple matches returns a single match)
- - Salesforce Picklist transformation
- - Salesforce Merge transformation
- - Sorter transformation
- - Stored Procedure transformation with exception handling
- - Transaction Control transformation
- - Web Services consumer transformation
- - XML Generator transformation with flat file or database sources
- - XML Parser transformation with flat file or database sources
- •If you use a mapplet in a Data Synchronization task, the PowerCenter mapplet cannot contain multiple Input transformations.
- •If you use a mapplet in a Mapping Configuration task, the PowerCenter mapplet can contain multiple Input transformations.
- •Informatica Cloud flattens PowerCenter mapplets with multiple input groups into mapplets with one input group. Therefore, the ports in each input group in the PowerCenter mapplet must have unique names. If the names are not unique, rename the input ports in PowerCenter before you export the PowerCenter XML file that contains the mapplet.