Question 9
Refer to the exhibit.
In the data load editor, the tables are loaded in the following sequence:
OrderHeader
OrderDetails
Products
The three tables CANNOT be modified as all fields are required. A data architect must create a Cost of Goods Sold (COGS) field calculated as UnitCost* Quantity. Some products may NOT have UniCost, so the COGS value must be zero for these products.
How should the data architect meet this requirement?
1. Load the Products table as the first table
2. Create a new field in the OrderDetails table: Quantity * IsNull (UnitCost) as COGS
1. Perform a preceding load on the Product table
2. Create a new field in the OrderDetails table: if((UnitCost - null() or ", 0) * Quantity as COGS
1. Join the Products and OrderDetails on ProductID
2. Create a new field in the OrderDetails table: Replace(Null, 0, UnitCost) * Quantity as COGS
1. Create a mapping load table as the first table from the Product table
2. Create a new field to the OrderDetails table: ApplyMap ('UnitCost_Map', ProductID, 0) * Quantity as COGS
Correct answer: D