The input file of orders from affiliate A.

The input file of orders from affiliate B.

Union transformation that combines the rows from the input files. The Union transformation returns an alpha numeric order number for all orders.

SQL transformation that assigns an order number to each row and increments a sequence number in a relational table.

Filter transformation that filters rows that have NULL order numbers from the mapping.

Flat file that receives the original customer order number and the SQL error messages that the database might return. The SQL_Errors file has the following structure:

Column	Size	Description
Orig_OrderID	20	Original order number
SQL_Error	4096	Error message

The SQL_Errors file receives two rows for each order because the SQL transformation returns a row for each SQL statement. Each row contains NULL in the SQL_Error column unless the database returns an error message for the SQL statement.

Logical data object that contains the single view of the customer orders. Order receives one row for each order.