Table of Contents

Search

  1. Preface
  2. Mappings
  3. Parameters
  4. CLAIRE recommendations
  5. Data catalog discovery
  6. Visio templates

Mappings

Mappings

Step 2. Configure a source

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.
  1. On the mapping canvas, click the Source transformation to select it.
  2. In the Properties panel, click
    General
    and enter src_FF_Account for the Source transformation name.
  3. 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
    .
    The following image shows the src_FF_Account details in the Properties panel:
    The Properties panel displays the source connection, source type, and source object for the FF_Account source transformation.
    To view the source fields and field metadata, click the
    Fields
    tab.
  4. To save the mapping and continue, click
    Save
    .