Which field did you use to sort data to merge with the Item_Master_Dim table?
24. Question 24 Which field did you use to sort data to merge with the Item_Master_Dim table? 1 point ItemId ItemMasterKey ItemMasterDim ItemMasterId
-
-
How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Cust_Vendor_Dim table?
23. Question 23 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Cust_Vendor_Dim table? 1 point 10 9…
-
Which field did you use to sort data to merge with the Cust_Vendor_Dim table?
22. Question 22 Which field did you use to sort data to merge with the Cust_Vendor_Dim table? 1 point CustVendorKey Trans_Type_Key State AddreBookId
-
How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Trans_Type_Dim table?
21. Question 21 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Trans_Type_Dim table? 1 point 13 12…
-
How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Date_Dim table?
19. Question 19 How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Date_Dim table? 1 point 12 …
-
How many rows appear in the preview result (or the Written column in the step metrics) after filtering rows of the Access table with null values?
17. Question 17 How many rows appear in the preview result (or the Written column in the step metrics) after filtering rows of the Access table with null values? 1…
-
How many rows are inserted into the Inventory_Fact table?
16. Question 16 How many rows are inserted into the Inventory_Fact table? 1 point 9 11 10 8
-
For this question, make sure the Quantity is used as the B (right) field in the Calculator step. The ExtCost calculated for the Inventory_Fact table for Customer 1 is
15. Question 15 For this question, make sure the Quantity is used as the B (right) field in the Calculator step. The ExtCost calculated for the Inventory_Fact table for Customer…
-
The UnitCost calculated for the Inventory_Fact table for Customer 1 is
14. Question 14 The UnitCost calculated for the Inventory_Fact table for Customer 1 is 1 point 3.32 11.22 1.71 33.11
-
How many rows appear in the preview result (or the Written column in the step metrics) after merging with the Currency_Dim table?
13. Question 13 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 …