Task 1. Create a Mapping Specification

1. From the New Assets panel in the Design workspace, click Mapping Specification.
The New Mapping Specification window appears.
2. Enter Customer_Data as the mapping specification name.
3. Select the Customers folder in your tutorial project.
4. Click Next.
5. On the Sources panel, click the Add Source Object icon and select the Accounts and Customers sources from the Customers folder.
Use the check boxes to select both sources.
6. Click OK.
7. Click Next.
8. On the Joins panel, click the New Join icon to create a join and select the edit options to configure the join.
9. In the Name field, enter CustomerData.
10. In the Join Type field, accept the default Normal.
11. Select Accounts as the Master table and Customers as the Detail table.
12. Select Simple Join.
13. On the Join Conditions panel, modify the join condition to display those customer accounts that have purchased financial products.
Specify the following join condition:
• - Master Column Name. Select the ACCOUNTS.ACCOUNT_CUSTOMER column.
• - Operator. Select the "=" operator.
• - Detail Column Name. Select the CUSTOMERS.CUSTOMER column.
14. Click OK.
15. Click Next.
16. On the Target Object panel, select the Customer_Accounts table data object.
17. Click Finish.
The Customer_Data mapping specification opens on the Column Mapping tab.