Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerCenter H2L
  • All Products

Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Using the SQL Transformation in an Informatica Developer Mapping

Using the SQL Transformation in an Informatica Developer Mapping

Using the SQL Transformation in an Informatica Developer Mapping

Back Next

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!