Task 1. Create a Target Data Object
In this task, you create an LA_Customers_tgt data object that you can write parsed names to.
To create a target data object, complete the following steps:
1. Create an LA_Customers_tgt data object based on the LA_Customers.csv file.
2. Configure the read and write options for the data object, including file locations and file names.
3. Add Firstname and Lastname columns to the LA_Customers_tgt data object.
Step 1. Create an LA_Customers_tgt Data Object
In this step, you create an LA_Customers_tgt data object based on the LA_Customers.csv file.
1. Click File > New > Data Object.
The New window opens.
2. Select Flat File Data Object and click Next.
3. Verify that Create from an existing flat file is selected.
4. Click Browse and navigate to LA_Customers.csv in the following directory: <Informatica Installation Directory>\clients\DeveloperClient\Tutorials
5. Click Open.
6. In the Name field, enter LA_Customers_tgt.
7. Click Next.
8. Click Next.
9. In the Preview Options section, select Import column names from first line and click Next.
10. Click Finish.
The LA_Customers_tgt data object appears in the editor.
Step 2. Configure Read and Write Options
In this step, you configure the read and write options for the LA_Customers_tgt data object, including file locations and file names.
1. Verify that the LA_Customers_tgt data object is open in the editor.
2. In the editor, select the Read view.
3. Click Window > Show View > Properties.
4. In the Properties view, select the Runtime view.
5. In the Value column, double-click the source file name and type LA_Customers_tgt.csv.
6. In the Value column, double-click to highlight the source file directory.
7. Right-click the highlighted name and select Copy.
8. In the editor, select the Write view.
9. In the Properties view, select the Runtime view.
10. In the Value column, double-click the Output file directory entry.
11. Right-click and select Paste to paste the directory location you copied from the Read view.
12. In the Value column, double-click the Header options entry and choose Output Field Names.
13. In the Value column, double-click the Output file name entry and type LA_Customers_tgt.csv.
14. Click File > Save to save the data object.
Step 3. Add Columns to the Data Object
In this step, you add Firstname and Lastname columns to the LA_Customers_tgt data object.
1. In the Object Explorer view, browse to the data objects in your tutorial project.
2. Double-click the LA_Customers_tgt data object.
The LA_Customers_tgt data object opens in the editor.
3. Verify that the Overview view is selected.
4. Select the FullName column and click the New button to add a column.
A column named FullName1 appears.
5. Rename the column to Firstname. Click the Precision field and enter "30."
6. Select the Firstname column and click the New button to add a column.
A column named FirstName1 appears.
7. Rename the column to Lastname. Click the Precision field and enter "30."
8. Click File > Save to save the data object .