Your organization receives orders and customer information from multiple sources. The order numbers from one source are alphanumeric. The orders from another source are numeric. You need to combine the orders into one format and generate a company order number for each order.

This article explains how to create a logical data object model to represent a single view of the customer data and the order data. The Order logical data object in the model defines the format of the order numbers. The article also explains how to configure an SQL transformation to generate an order number for each order row in the logical data object mapping.

Complete the following tasks:

Define the physical data objects that contain order data.
Import the logical data object model that defines a single view of the order data and the customer data.
Create a logical data object mapping that maps orders from multiple sources to the Order logical data object. Include an SQL transformation to create an unique order number for each source row.
Run the mapping to view results.