Which two tasks can the Slowly Changing Dimensions (SCD) stage perform? (Choose two.)
A.
Look up whether a record with a matching business key value exists in a dimension table. If it
does,add new values for selected fields to values lists for those fields.
B.
Look up whether a record with a matching business key value exists in a fact table. If it does
not,retrieve a new surrogate key value and insert a new row into the fact table.
C.
Look up whether a record with a matching business key value exists in a dimension table. If it
does not,retrieve a new surrogate key value and insert a new row into the dimension table.
D.
Look up whether a record with a matching business key value exists in a dimension table. If it
does,mark the record as not-current,and generate a new record with new values for selected
fields.
Explanation: