Which field did you use to sort rows before the merge with the Trans_Type_Dim table?
4. Question 4 Which field did you use to sort rows before the merge with the Trans_Type_Dim table? 1 point TransTypeKey CustVendorKey ItemMasterKey TransTypeCodeId
How many rows appear in the preview result (or the Written column in the step metrics) after merging the Excel file with the Date_Dim table?
3. Question 3 How many rows appear in the preview result (or the Written column in the step metrics) after merging the Excel file with the Date_Dim table? 1 point…
How many rows appear in the preview result (or the Written column in the step metrics) after filtering records of the Excel file for null values?
1. Question 1 How many rows appear in the preview result (or the Written column in the step metrics) after filtering records of the Excel file for null values? 1…
In the Gartner market summary of data integration products, vision involves
9. Question 9 In the Gartner market summary of data integration products, vision involves 1 point recent stock price performance. firm size and resources. breadth and integration…
In Pentaho Data Integration, a transformation is
7. Question 7 In Pentaho Data Integration, a transformation is 1 point a directed link connecting two steps. a data flow with steps connected by hops….
In the Gartner market summary of data integration products, ability to execute involves
9. Question 9 In the Gartner market summary of data integration products, ability to execute involves 1 point product performance features. recent stock price performance. breadth and…
Publisher/subscriber specification is an important part of change data capture in a data integration tool.
3. Question 3 Publisher/subscriber specification is an important part of change data capture in a data integration tool. 1 point True False
In Pentaho Data Integration, a step is
7. Question 7 In Pentaho Data Integration, a step is 1 point an execution sequence. a data flow with steps connected by hops. a process in a…
The ELT architecture
5. Question 5 The ELT architecture 1 point performs transformations and loading concurrently. performs transformations after loading typically using a DBMS for transformations. requires a DBMS to…
Identify TRUE statements about the Open Core Model.
10. Question 10 Identify TRUE statements about the Open Core Model. 1 point Commercial software versions with proprietary extensions beyond the core product Paid subscription services to augment core…
