When the Integration Service writes a new dimension to the target, the
columns remain null. Each time the Integration Service updates a dimension, it writes existing data into the corresponding
column, and then writes updates into the original column. As a result, each row in a Type 3 Dimension target contains current dimension data. Each row also contains the previous versions of dimension data, if the dimension has changed.