You can update a source definition to add business names or to reflect new column names, datatypes, or other changes. You can update a source definition in the following ways:
Edit the definition.
Manually edit the source definition if you need to configure properties that you cannot import or if you want to make minor changes to the source definition.
Reimport the definition.
If the source changes are significant, you may need to reimport the source definition. This overwrites or renames the existing source definition. You can retain existing primary key-foreign key relationships and descriptions in the source definition being replaced.
When you update a source definition, the Designer propagates the changes to all mappings using that source. Some changes to source definitions can invalidate mappings.
If the changes invalidate the mapping, you must open and edit the mapping. Then click Repository > Save to save the changes to the repository. If the invalidated mapping is used in a session, you must validate the session.