PrepAway - Latest Free Exam Questions & Answers

Which Slowly Changing Dimension (SCD) stage statement i…

Which Slowly Changing Dimension (SCD) stage statement is TRUE?

PrepAway - Latest Free Exam Questions & Answers

A.
Surrogate keys are used to join a dimension table to a fact table in a normalized schema database

B.
Each SCD stage processes multiple dimensions and performs lookups by using an equality matching

C.
Purpose codes are part of the table metadata that the SCD stage propagates to the dimension insert link.

D.
Actual dimensions changes are applied to the lookup table in memory and are mirrored to the dimension
update link

Explanation:
https://www-
01.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.ds.parjob.dev.doc/topic
s/c_parjdev_Slowly_Changing_Dimension_Stage.html


Leave a Reply