How should you use a MERGE T-SQL statement to accomplish this goal?

DRAG DROP

You are creating a sales data warehouse. When a product exists in the product dimension, you update the product name. When a product does not exist, you insert a new record.

In the current implementation, the DimProduct table must be scanned twice, once for the insert and again for the update. As a result, inserts and updates to the DimProduct table take longer than expected.

You need to create a solution that uses a single command to perform an update and an insert.

How should you use a MERGE T-SQL statement to accomplish this goal? (To answer, drag the appropriate answer choice from the list of options to the correct location or locations in the answer area.

You may need to drag the split bar between panes or scroll to view content.)

View Answer

Answer:

Explanation:

References:

http://msdn.microsoft.com/en-us/library/bb510625.aspx

http://msdn.microsoft.com/en-us/library/cc280522.aspx