Exercise: Denormalize the Sales Order Tables

For more detailed information, please see Conditional Lookup Fields.

Steps:

  1. If not already added, be sure to map the SalesOrderHeader and SalesOrderDetails from the Business Unit and add them to the DSA using the functions previously described in this training.
  2. Reorder the tables so that SalesOrderHeader is above SalesOrderDetails.
  3. Open SalesOrderHeader table in a new window (use ctrl-w).
  4. Drag the SalesOrderID field from SalesOrderHeader and drop it on the same field in the SalesOrderDetail table to create a relation.
  5. Drag the fields OrderDate, ShipDate and CustomerID from SalesOrderHeader table and drop them on the SalesOrderDetail table name to create conditional lookup fields.

Next