Implementing a SQL Data Warehouse — Question 41

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 designing a data warehouse and the load process for the data warehouse.
You have a source system that contains two tables named Table1 and Table2. All the rows in each table have a corresponding row in the other table.
The primary key for Table1 is named Key1. The primary key for Table2 is named Key2.
You need to combine both tables into a single table named Table3 in the data warehouse. The solution must ensure that all the nonkey columns in Table1 and
Table2 exist in Table3.
Which component should you use to load the data to the data warehouse?

Answer options

Correct answer: G

Explanation

The correct answer is G, the Lookup transformation, as it allows for retrieving additional data from Table2 based on the keys from Table1, ensuring that all relevant non-key columns are included in Table3. The other options do not appropriately facilitate the merging of two tables while preserving all necessary data; for example, the Merge transformation does not handle lookups from another table.