To create a primary-key foreign-key relationship between customers and orders, each group must contain the customer number.
Add a Customer_Fkey port below Order_Date in the Orders group of the REST Output transformation.
The Customer_Fkey port receives a customer number. You need to add this port to receive a customer number in the Orders group and to populate the foreign key. The customer number does not appear with each order in the output.
Link the Customer_Key from the
Ports
panel to the Key_Orders_Resource on the
Output
panel. To create a link, click the Customer_Key to select it, then select the Key_Orders_Resource. Click the
Map
icon on the
Ports
panel to create the link.
You cannot drag a port to create a link.
Select the Order_Key port and the Key_Orders element. Click
Map
to create the link.
Order_Key must have links to the Key_Orders element and the Order_Key element.
Select the Customer_Fkey port and the Fkey_Orders_Resource element. Click
Map
to create the link.
The following image shows the output mapping with the links to the keys: