Using the SQL Transformation in an Informatica Developer Mapping

Using the SQL Transformation in an Informatica Developer Mapping

Input Files

Input Files

The input files are flat file order files from different affilates. The content is similar, but the order numbers for one affiliate are alphanumeric. The order numbers from the other affiliate are numeric.
The following figure shows the columns in ReadOrders_Affiliate_A order file:
Order_Id
Customer
Street_Address
City
State
Order_Amt
Product_Id
Product_Desc
A00001
787
38 Busey Street
Redwood City
CA
10.00
555555
Windshield_Wiper
A00002
777
44 Lenolt St
Redwood City
CA
23.50
555577
Door_Handle
A00003
345
41 E Summit Dr
Dardenelle
CA
350.00
450088
Seat_Covers
A00004
120
777 Lakeview Rd
New York
NY
10.00
555555
Windshield_Wiper
A00005
333
910 Castle Hill
Fort Collins
CO
23.50
555577
Door_Handle
A00006
56
216 8th Avenue
San Bruno
CA
350.00
450088
Seat_Covers
A00007
56
216 8th Avenue
San Bruno
CA
75.00
451100
Retractable_Anenna
A00008
187
235 Stoney Rd
Los Angeles
CA
10.00
300000
Wax
A00009
187
235 Stoney Rd
Los Angeles
CA
350.00
450088
Seat_Covers
A00010
200
290 Wave St
San Diego
CA
10.00
555555
Windshield_Wiper
The following figure shows the columns in the ReadOrders_Affiliate_B file:
Order_ID
Product_Number
Description
Customer_ID
Address
City
State
Order_Amt
100000000
123456789
Window Cleaner
100
252 Handy Drive
Foster City
Ca
5.95
100000001
233334545
Octane Booster
121
16 Rut Street
Redwood City
Ca
3.95
100000002
333333567
Rug Shampoo
155
87 Oliver Street
San Mateo
Ca
4.95
100000003
222222456
Oil
183
566 Pamela Lane
Las Vegas
Ca
3.95
100000004
333333567
Rug Shampoo
201
33 VistaPark
Moorpark
Ca
6.95
100000005
111115678
Tire Pump
444
212 Corolla Store
Kimmel
Or
49.99
100000006
444455566
Floor Mat
222
902 Valencia St
San Francisco
Ca
39.99
100000007
123456789
Window Cleaner
222
902 Valencia St
San Francisco
Ca
5.95
100000008
333333567
Rug Shampoo
115
44 Miranda Rd
Palo Alto
Ca
6.95
100000009
233334545
Octane Booster
127
22 Rock Cred Lane
Bakersfield
Ca
3.95

0 COMMENTS

We’d like to hear from you!