Transformation installation

The installation process:

• Generates or updates a PL/SQL program for each table-level transformation and corresponding packages in the database.

• Links the transformation programs to the source and target models and upgrade-installs the models if they are not already installed.

• Checks out the target tables and generates the auxiliary columns required to maintain the source system context and data lineage tracing for each record, if they have not already been created. See How the system tracks data lineage.

  Note:

  Because of this, if the table-level transformation has never been installed, the target model must be either:

  • Checked in.

  • Checked out by the same user who is installing the transformation.

  If not, the installation fails. So if you are installing a table-level transformation for the first time, see if the target model is checked out. If it is checked out by a different user, ask him or her to check it in before you install the transformation.

• Installs the target model in upgrade (regular) mode.

  Even if you select Full installation to install the transformation, the behavior is the same as for regular installation. If and only if a table has had destructive changes, the installation job drops and recreates the table and deletes all its data f rom those tables.See Destructive and nondestructive changes.