A Source transformation extracts data from a source. When you add a Source transformation to a mapping, you define the source connection, source objects, and source properties related to the connection type. For some connection types, you can use multiple source objects within a Source transformation.
You can use a Source transformation to read data from the following source types:
•File. The Source transformation can read data from a single source file or a file list.
•Database. The Source transformation can read data from a single source table or multiple source tables.
•Web service. The Source transformation can read data from a single web service operation.
•Data Integration connectors. The Source transformation can read data from a single source object, a multi-group source object, or multiple source objects based on the connection type.
For more information about sources for individual connectors, see the Connectors section of the online help.
You can use one or more Source transformations in a mapping. If you use two Source transformations in a mapping, you can use a Joiner transformation to join the data. If you use multiple Source transformations with the same structure, you can use a Union transformation to merge the data into a single pipeline.
In a Source transformation, the source properties that appear vary based on the connection type. 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 specify the file type and configure the file formatting options.