Task 1. Create a Target Data Object
In this task, you create a target data object, configure the write options, and add ports.
To create and configure the target data object, complete the following steps:
1. Create an All_Customers_av_tgt data object based on the All_Customers.csv file.
2. Configure the read and write options for the data object, including the file locations and file names.
3. Add ports to the data object to receive the match code values generated by the Address Validator transformation.
Step 1. Create the All_Customers_av_tgt Data Object
In this step, you create an All_Customers_av_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. Click Browse next to this selection, find the All_Customers.csv file, and click Open.
4. In the Name field, enter All_Customers_av_tgt.
5. Click Next.
6. Click Next.
7. In the Preview Options section, select Import column names from first line and click Next.
8. Click Finish.
The All_Customers_av_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_av_tgt data object, including the target file name and location.
1. Verify that the All_Customers_av_tgt data object is open in the editor.
2. In the editor, select the Read view.
3. Select 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_av_tgt.csv.
6. In the Value column, double-click to highlight the source file directory path.
7. Right-click the highlighted path and 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 this entry and select Paste to add the path 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_av_tgt.csv.
14. Select File > Save to save the data object.
Step 3. Add Ports to the Data Object
In this step, you add two ports to the All_Customers_av_tgt data object so that the Address Validator transformation can write match code values to the target file. Name the ports MailabilityScore and MatchCode.
The MailabilityScore value describes the deliverability of the input address. The MatchCode value describes the type of match the transformation makes between the input address and the reference data addresses.
1. In the Object Explorer view, browse to the data objects in your tutorial project.
2. Double-click the All_Customers_av_tgt data object.
The All_Customers_av_tgt data object opens in the editor.
3. Verify that Overview is selected.
4. Select the final port in the port list. This port is named MiscDate.
5. Click New.
A port named MiscDate1 appears.
6. Rename the MiscDate1 port to MailabilityScore.
7. Select the MailabilityScore port.
8. Click New.
A port named MailabilityScore1 appears.
9. Rename the MailabilityScore1port to MatchCode.
10. Click File > Save to save the data object.