Which three actions should you perform?

You are creating a product dimension table and a SQL Server Integration Services (SSIS)
package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.

You are creating a product dimension table and a SQL Server Integration Services (SSIS)
package that will load the table.
You need to keep a history in the table of changes to the names of products.
Which three actions should you perform? Each correct answer presents part of the solution.

A.
Add a Slowly Changing Dimension transformation to the package.

B.
Enable Change Data Capture for the table.

C.
Create an inferred member column in the table.

D.
From the Slowly Changing Dimension Wizard, set the name column to Type 3.

E.
Create an end date column in the table.

F.
Create a start date column in the table.



Leave a Reply 1

Your email address will not be published. Required fields are marked *