Exercise: Denormalize the Sales Order Tables
For more detailed information, please see Conditional Lookup Fields.
Steps:
- 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.
- Reorder the tables so that SalesOrderHeader is above SalesOrderDetails.
- Open SalesOrderHeader table in a new window (use ctrl-w).
- Drag the SalesOrderID field from SalesOrderHeader and drop it on the same field in the SalesOrderDetail table to create a relation.
- Drag the fields OrderDate, ShipDate and CustomerID from SalesOrderHeader table and drop them on the SalesOrderDetail table name to create conditional lookup fields.
Note: Video is free of audio