Database Reference
In-Depth Information
Figure 11-3 . SCD Wizard output
Of all of the SCD design patterns, the SCD Wizard is arguably the easiest to use for
simple SCD scenarios, and it offers the fastest turnaround at design time. For small,
simple dimensions, the wizard can be an effective tool for managing changing data.
However, the SCD Wizard does have some significant drawbacks.
Performance: The wizard performs reasonably well against small
sets of data. However, because many of the operations are performed
on a row-by-row basis, leveraging this transform against sizeable di-
mensions can cause a significant performance bottleneck. Some data
warehouse architects have strong feelings against the SCD Wizard,
and this is often the chief complaint.
 
Search WWH ::




Custom Search