Source Transformation
A Source transformation defines the source connection and source objects for a mapping. It can also define source properties related to the connection type. For some connection types, you can use multiple source objects within a Source transformation.
You can use one or more Source transformations in a mapping. Use a Joiner transformation to join data from two Source transformations.
The source properties that appear depend on the connection type that you select. For example, when you select a Salesforce connection, you can use multiple related source objects and configure the Salesforce API advanced source property. In contrast, when you select a flat file connection, you can use a single flat file source object.
You can use the following source systems in a Source transformation:
- •File. You can use a single source file or a file list.
- •Database. You can use a single source table or multiple source tables.
- •Informatica Cloud Connectors. Each Informatica Cloud Connector determines whether you can use single source objects or multiple source objects.
When you select a source object, the Properties panel displays the following areas and information:
- •General. Use to configure the name and a description for the source.
- •Source. Use to select the connection and source object, and to configure other available properties, such as filter and sort query options and advanced source properties.
- •Fields. Use to configure the source fields that you want to use in the mapping.