You have a data warehouse that contains a fact table named Table1 and a Product table named Dim1.
Dim1 is configured as shown in the following table.
You are adding a second OLTP system to the data warehouse as a new fact table named Table2.
The Product table of the OLTP system is configured as shown in the following table
You need to modify Dim1 to ensure that the table can be used for both fact tables.
Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A . Modify the data type of the Weight column in Dim1 to decimal (19, 2).
B . Add the SalesUnit column to Dim1.
C . Modify the data type of the Name column in Dim1 to varchar (85).
D . Drop the ProductKey column from Dim1 and replace the column with the ProductIdentifier column.
E . Drop the Color column from Dim1.
F . Modify the data type of the ProductKey column in Dim1 to char (18).
Answer: AD