Task 2. Import the LA_Customers Flat File Data Object
In this task, you import a physical data object from a flat file that contains customer data from the Los Angeles office.
1. In the Object Explorer view, select the tutorial project.
2. Click File > New > Data Object.
The New dialog box appears.
3. Select Physical Data Objects > Flat File Data Object and click Next.
The New Flat File Data Object dialog box appears.
4. Select Create from an Existing Flat File.
5. Click Browse and navigate to LA_Customers.csv in the following directory: <Informatica Installation Directory>\clients\DeveloperClient\Tutorials
6. Click Open.
The wizard names the data object LA_Customers.
7. Click Next.
8. Verify that the code page is MS Windows Latin 1 (ANSI), superset of Latin 1.
9. Verify that the format is delimited.
10. Click Next.
11. Verify that the delimiter is set to comma.
12. Select Import column names from first line.
13. Click Finish.
The LA_Customers physical data object appears under Physical Data Objects in the tutorial project.
14. Click the Read view and select the Output transformation.
15. Click the Runtime tab on the Properties view.
16. Set the Source File Directory to the following directory on the Data Integration Service machine: <Informatica Installation Directory>\server\Tutorials
17. Click File > Save.