Task 1. Import the Boston_Customers Flat File Data Object
In this task, you import a physical data object from a file that contains customer data from the Boston 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 Objectand 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 Boston_Customers.csv in the following directory: <Informatica Installation Directory>\clients\DeveloperClient\Tutorials
6. Click Open.
The wizard names the data object Boston_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 Boston_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.