Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Step 3. Add the Transformation to a Mapping

Step 3. Add the Transformation to a Mapping

Add the Data Processor transformation to a mapping. To test that the mapping works, run the mapping.
  1. In the
    Object Explorer
    view, create a mapping, or select a mapping in the Explorer and select
    Open Mapping
    .
  2. Copy the file
    Patient_Test_Example.xml
    to the Informatica repository server, then create a flat file named
    Input
    from the file
    Patient_Test_Example.xml
    . Ensure that the file is read as a one line of input.
    You must copy the file
    Patient_Test_Example.xml
    to the Informatica repository server.
  3. Drag the Field1 port in the source to the Input input port in the Data Processor transformation.
    When the mapping runs it reads input from the file designated by the path in the input physical data object.
  4. Create a flat file named
    Output
    and add the fields
    Number
    ,
    PatientID
    ,
    TestID
    ,
    ChemicalID
    ,
    Level
    , and
    Status
    . To link the Data Processor transformation to the Output flat file, perform the following steps:
    1. Drag the Output output port in the Data Processor transformation to the Field port in the target.
    2. Drag the Fkey_Patient_Records port in the Data Processor transformation to the Number port in the target.
    3. Drag the Patient_ID port in the Data Processor transformation to the PatientID port in the target.
    4. Drag the Test_ID port in the Data Processor transformation to the TestID port in the target.
    5. Drag the Chemical_ID port in the Data Processor transformation to the ChemicalID port in the target.
    6. Drag the Level port in the Data Processor transformation to the Level port in the target.
    7. Drag the Status port in the Data Processor transformation to the Status port in the target.
  5. To save the mapping, select the mapping, then click
    File
    Save