Valid 70-767 Dumps shared by ExamDiscuss.com for Helping Passing 70-767 Exam! ExamDiscuss.com now offer the newest 70-767 exam dumps, the ExamDiscuss.com 70-767 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com 70-767 dumps with Test Engine here:
Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question. You are loading data from an OLTP database to a data warehouse. The OLTP database includes a table for sales data and a table for refund data. The data warehouse contains a single table for all the sales and refund data. Which component should you use to load the data to the data warehouse?
Correct Answer: C
Explanation/Reference: Explanation: The Merge transformation combines two sorted datasets into a single dataset. The rows from each dataset are inserted into the output based on values in their key columns. By including the Merge transformation in a data flow, you can merge data from two data sources, such as tables and files. References: https://docs.microsoft.com/en-us/sql/integration-services/data-flow/transformations/merge- transformation?view=sql-server-2017