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 implementing the data load process for a data warehouse.
The data warehouse uses daily partitions to store data added or modified during the last 60 days. Older data is stored in monthly partitions.
You need to ensure that the ETL process can modify the partition scheme during the data load process.
Which component should you use to load the data to the data warehouse?
Correct Answer: E
Explanation/Reference:
Incorrect Answers:
A: The Slowly Changing Dimension transformation coordinates the updating and inserting of records in data warehouse dimension tables.
References: https://social.technet.microsoft.com/wiki/contents/articles/50781.dynamic-management-of- ssas-partitions-with-ssis.aspx