Developer Mapping Guide

10.5.4
- 10.5.6
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2
- 10.2.1

Back Next

Run the Mapping for the orders_FF Source

Validate the mapping and run the

m_ReplicationTemplate

mapping for a different source and target. The mapping reads from the orders_FF source file and writes to the ordersTrim.csv target file.

In the mapping editor, click

Edit

Validate

When the mapping is valid, click

File

Save

to save the mapping.

Click

Run

Mapping

The

Run Mapping

window displays the progress of the mapping run. The mapping runs and writes the output to the target file.

To view the results written to the target file, navigate to the target directory on the system where Informatica services is installed:

<Informatica Installation Directory>\tomcat\bin\target

Open the

ordersTrim.csv

file to verify that the string values do not have spaces in the beginning and end.

Each line of the file lists data for the columns in the order that they appeared in the target object as Customer_Id, Order_ID, Company, CompanyAddress, CompanyCity, and so on. For example, the first five lines of the file contain the following data where the blanks from the beginning and end of strings are removed:

10110085,O-5079,JOSEPHTHAL LYON & ROSS,96 FISHER ROAD,MAHWAH,NJ,7430,PARKE PERSLEY OR RAYFORD LECROY,96 FISHER ROAD,MAHWAH,NJ,American Express,CHARGE,Account Executive,UPA,United Parcel Service Air,44162,$21.00,Generic,O/L/B P/W L/S TAWNY SHIMMER .08 OZ.
10110086,O-6658,NRCA,10255 W.HIGGINS RD.,ROSEMONT,IL,60018-5607,ROLANDA SORTO,10255 W.HIGGINS RD.,ROSEMONT,IL,American Express,CHARGE,Account Executive,UPA,United Parcel Service Air,44163,$56.40,Generic,O-L.B PW LIPSTYLO LASTING PERFECTION .08 OZ.
10110087,O-8195,POND EQUITIES,4522 FT. HAMILTON PKWY.,BROOKLYN,NY,11219,KONSTANTIN PEDDICORD,4522 FT. HAMILTON PKWY.,BROOKLYN,NY,American Express,CHARGE,Account Executive,UPA,United Parcel Service Air,44164,$78.00,Generic,O/L/B P/W L/S TAWNY SHIMMER LASTING PERFECTION LIPSTYLO TAWNY SHIMMER .08 OZ.
10110088,O-9130,SCHRODER & COMPANY,787 SEVENTH AVENUE,NEW YORK,NY,10019,GIORGIA TWITCHELL,787 SEVENTH AVENUE,NEW YORK,NY,American Express,CHARGE,Account Executive,UPA,United Parcel Service Air,44165,$14.00,Generic,A/COL L PERFECTION L/S REF P SUPREME LASTING PERFECTION LIPSTYLO TAWNY SHIMMER .08 OZ.
10110089,O-9352,YUASA TRADING COMPANY (AMERICA),150 EAST 52ND STREET,NEW YORK,NY,10005,STEFFI MCGLOWN,150 EAST 52ND STREET,NEW YORK,NY,American Express,CHARGE,Account Executive,UPA,United Parcel Service Air,44166,$54.00,Generic,O/L/B L PERFECTION REF LIPSTYLO COFFEE PEACH SUPREME .08 OZ.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Run the Mapping for the orders_FF Source

Run the Mapping for the orders_FF Source