Effective Dates

Future effective dates in TIBCO MDM are a means to complete and confirm records that become active at a specified date in the future.

This is useful for expected changes such as new product releases, changes to employment details, and price changes.

When using future effective dates, keep the following best practices in mind:

  • Always try to use effective dates in a linear fashion between record versions. Ensure that the later version of a record has the later effective date than the earlier versions. If this is not the case, the earlier versions (for example, version 5 with a later effective date than version 6) can overwrite the golden copy, which can lead to data inconsistencies. To avoid this, use rulebases and approval cycles to confirm the dates being used are correct and that earlier dates are not used.
  • Effective dates in repositories and records have an impact on both memory and performance in TIBCO MDM.
  • Versions are only identifiers and do not imply ordering. A version 6 may become the golden copy before version 3.