Database Reference
In-Depth Information
Figure 11-2 . The SCD Wizard showing alignment of columns
From there, the wizard will guide you through the selection of the necessary ele-
ments of the SCD configuration, including the following:
• Which columns should be engaged as part of the SCD, along with the
option to handle changes as simple updates (Type 1) or historical values
(Type 2).
• How to identify current vs. expired rows, if any Type 2 columns are
present; you can specify either a flag or a date span to indicate currency
of SCD records.
• How to handle inferred members (discussed in more depth shortly).
When you've completed the SCD Wizard, several new elements are automatically
added to the data flow. Figure 11-3 shows an example of the transforms and destina-
tions added when using a combination of Type 1 and Type 2 fields, fixed-attribute
(static) fields, and inferred member support. The SCD Wizard adds only those compon-
ents pertinent to the design specified, so the final result may look a bit different than
the example in this figure, depending on how the wizard is configured.
 
 
Search WWH ::




Custom Search