Mappings

Back Next

Step 2. Configure a source

In the following procedure, you create a Source transformation to specify the source object.

When you design a mapping, the first transformation you configure is the Source transformation. You specify the source object in the Source transformation. The source object represents the source of the data that you want to use in the mapping. You add the source object at the beginning of mapping design because the source properties can affect the downstream data. For example, you might filter data at the source, which affects the data that enters downstream transformations.

Configure the sample Account flat file as the source object.

On the mapping canvas, click the Source transformation to select it.

In the Properties panel, click

General

and enter src_FF_Account for the Source transformation name.

Specify which connection to use based on the source object. In this case, the source object is a flat file so the connection needs to be a flat file connection.

Click

Source

and configure the following properties:

Source detail	Description
Connection	Connection to the sample source file. Select the flat file connection that you set up before you started the tutorial.
Source Type	Source object or a parameter, which is a placeholder for the source object that you specify when you run a task based on the mapping. Select Single Object .
Object	Source object for the mapping. Click Select and navigate to the ACCOUNT.csv source file. Or, enter the full path to the source object and the source file name, for example, C:\Informatica\Tutorial\ACCOUNT.csv. If you want to view the data in the source file, you can click Preview Data .