Describe the three types of SCDs.
What will be an ideal response?
Most common techniques for dealing with SCDs that are not significant are called Type 1 and those
that are significant are called Type 2.
A Type 1 SCD overwrites the existing attribute value with the new value. This gives no tracking record
of historical values.
A Type 2 SCD captures the attribute values that were in effect at a point in time and relates them to the
business events in which they participated.
When a change occurs to a Type 2 SCD, a new record is created in the dimension table to capture the
new values that are to take effect from that point onwards or to the next change.
There is a third tracking technique called Type 3 SCD, which creates separate attributes for both the old
and new attribute values. However, Type 3 is less common because it involves changing physical
tables and is not very scalable.
You might also like to view...
A ____ is a computer that uses a browser to request information from a Web server.
A. server B. browser C. middle-man D. client computer
________ is a compressed graphic file format for raster data, which can lose data
Fill in the blank(s) with correct word
Match the following terms to their meanings:
I. operating system II. Windows 8 III. Start screen IV. Windows ID V. Windows 8 apps A. provides access to most-used applications in Windows 8 B. offers access to Microsoft resources on the Internet C. applications specifically designed to run in the Windows 8 Start screen D. software that directs computer activities E. Microsoft release in 2012
What defines the behavior of an object in object-oriented programming ?
What will be an ideal response?