You are developing a SQL Server Integration Services (SSIS) package to add a large amount of data to a fact table named factOrders. The factOrders table is partitioned by week and has a clustered index.
You need to load three weeks’ data into the factOrders table by using the most efficient method.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
Note:
* Need temporary tables.
* Can load data into the temporary tables in parallel
* ALTER TABLE
/ SWITCH
SWITCH [ PARTITION source_partition_number_expression ] TO [ schema_name. ] target_table [ PARTITION target_ partition_number_expression ]
Switches a block of data in one of the following ways:
Reassigns all data of a table as a partition to an already-existing partitioned table.
Switches a partition from one partitioned table to another.
Reassigns all data in one partition of a partitioned table to an existing non-partitioned table.
