This SQL script allows user to rename an Informatica MDM base object - not just its display name in MDM Hub but actual
database objects, from the main base object table through all its auxiliary tables and views. It accordingly
updates ORS repository - table names,
MDM Hub queries and packages, validation rules, business entity (formerly composite object) configuration, other MDM Hub objects,
as well as custom database stored procedures and packages, synonyms, materialized views and other database objects
dependent on the renamed objects. In the end, ORS repository validation status will not be negatively affected;
no new validation errors should be detected after ORS repository is validated.
The script does not rename MDM Hub staging tables, mappings, and landing tables related to the renamed base object.
It also does not rename MDM Hub subject areas; however, it determines and prints to the screen a list of subject areas that are
based on the renamed base objects so that user can manually rename them in IDD configuration tool.
The script can be run only in an Oracle database and therefore can only work with an Informatica MDM Hub installation that uses Oracle Database.
The script can be executed only by the owner of the ORS schema whose base object table is to be renamed.
The script requires a current and a new table names to be provided as arguments. A command line to execute the script should look like this:
@rename-BO C_PERSON C_PARTY -END
-END argument is required and must be the last one;
it indicates the end of supplied arguments.
Other optional parameters are supported. To see a list of all supported arguments, execute the script with an
-H or --help argument; in that case,
the -END argument is not required.
It is strongly recommended to first test the script in a test or development environment.
Look here for important information about BSUtils.com SQL scripts.