Slowly Changing Dimension - Type IV

Type IV

The Type 4 method is usually referred to as using "history tables", where one table keeps the current data, and an additional table is used to keep a record of some or all changes.

For the above example the original table name is Supplier and the history table is Supplier_History.

Supplier
Supplier_key Supplier_Code Supplier_Name Supplier_State
123 ABC Acme Supply Co IL
Supplier_History
Supplier_key Supplier_Code Supplier_Name Supplier_State Create_Date
123 ABC Acme Supply Co CA 22-Dec-2004

This method resembles how database audit tables and change data capture techniques function.

Read more about this topic:  Slowly Changing Dimension

Famous quotes containing the word type:

    The type of fig leaf which each culture employs to cover its social taboos offers a twofold description of its morality. It reveals that certain unacknowledged behavior exists and it suggests the form that such behavior takes.
    Freda Adler (b. 1934)