erwin Data Modeler: How can I link a column in one table to a column in another table so that any changes on one column will be also occur on the linked column?

Description:

How can I link a column in one table to a column in another table so that any changes on one column will be also occur on the linked column?

Solution:

You can create a link object to link the selected attribute/column in one table with another attribute/column from the other table.  When attributes/columns are linked, changes are synchronized between the objects based on the selected synchronization direction.

For this example we will link the column 'payment_transaction_number' with the column 'employee_ number'.

You can use the Link Wizard to create a link object by taking the following steps:

Therefore, any changes to the source column, such as changing the datatype or column name, will also be changed in the linked column.

NOTE:   the synchronization can be one sided (from either the original or linked Column) or for both sides.