Associate Change Date

The change date attribute is useful when incoming data's change date is other than current date. AttributeQuality has a property to point to an attribute which contains the name of change date of the attribute. This is useful when incoming data's change date is other than the current date. This attribute, if set, cannot be null for its value to be considered. The ChangeDate attribute should always be set to TIMESTAMP.

The associate change date is considered only when the new-computed weight equals the old-computed weight.

Consider the scenario, ORCL and SAP sources have a weight of 90 and record1 comes from the ORCL source and updated on 2015-09-28 3:14:07. If the same record1 comes from the SAP source on Sep/29/2015 with the ChangeDate attribute, the value is 2015-08-28 3:14:07.

Therefore, when the precedence is applied, the ORCL data is retained as the ChangeDate of the SAP source is older than the ORCL source.

Copyright © Cloud Software Group, Inc. All rights reserved.