Follow these steps to retrieve data from
your lookup file.
-
Add a new Text File Input step to your transformation.
This step retrieves the records from your lookup file. Do not add a hop
yet.
-
Open the Text File Input step window, then enter Read Postal
Codes in the Step name property.
-
Click
Browse to navigate to the
Zipssortedbycitystate.csv source file located in the
directory
...\design-tools\data-integration\samples\transformations\files.
-
Change File type to *.csv, select
Zipsortedbycitrystate.csv, and click
OK.
The path to the source file appears in the File or
directory field.
-
Click Add.
The path to the file appears under Selected files.