Task 1. Create a Target Data Object
In this task, you create an All_Customers_Stdz_tgt data object that you can write standardized data to.
To create a target data object, complete the following steps:
1. Create an All_Customers_Stdz_tgt data object based on the All_Customers.csv file.
2. Configure the read and write options for the data object, including file locations and file names.
Step 1. Create an All_Customers_Stdz_tgt Data Object
In this step, you create an All_Customers_Stdz_tgt data object based on the All_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 All_Customers.csv in the following directory: <Informatica Installation Directory>\clients\DeveloperClient\Tutorials
5. Click Open.
6. In the Name field, enter All_Customers_Stdz_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 All_Customers_Stdz_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 All_Customers_Stdz_tgt data object, including file locations and file names.
1. Verify that the All_Customers_Stdz_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 All_Customers_Stdz_tgt.csv.
6. In the Value column, double-click the Source file directory entry.
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 All_Customers_Stdz_tgt.csv.
14. Click File > Save to save the data object.