Week 5 Assignments of Data Warehouse Concepts Design and Data Integration Week- 5 Peer-graded Assignment: Assignment for module 5 Submit a document containing a screen snapshot for the transformation that…
28. Question 28 Which fields did you use to sort data to merge with the Currency_Dim table? 1 point Currency Currency_Id Currency_Name CurrencyDim
2. Question 2 Which fields did you use to sort data to merge with the Date_Dim table? Your answer should include fields in the Excel file and columns in the…
20. Question 20 Which field did you use to sort data to merge with the Trans_Type_Dim table? 1 point CustVendorKey ItemMasterKey TransTypeKey TransTypeCodeId
32. Question 32 How many rows are inserted into the Inventory_Fact table? 1 point 9 8 10 11
31. Question 31 For this question, make sure the Quantity is used as the B (right) field in the Calculator step. The ExtCost you calculated for the Inventory_Fact table for…
30. Question 30 The UnitCost you calculated for the Inventory_Fact table for Customer 2 is 1 point 29.07 1.82 24.17 22.22
29. Question 29 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Currency_Dim table? 1 point 11 …
27. Question 27 How many rows appear in the preview result (or the Written column in the step metrics) after merging with Branch_Plant_Dim table? 1 point 8 11 10…
26. Question 26 Which field did you use to sort data to merge with the Branch_Plant_Dim table? 1 point BranchPlantDim BPName BranchPlantID BranchPlantKey
