1.1 Approach to import Data to Target Schema

This topic gives an outline of the approach to import data to target schema.

Prepare the staging area only with the target version schema in this approach. This is the recommended approach.

Approach - Data Import to Target Schema

The steps involved in this method are as follows:

1. Prepare the staging area with the target version schema.
2. Insert the E-data (factory shipped static data) alone in the target schema using the consolidated insert scripts. You can do this using the Oracle® FLEXCUBE Investor Servicing Installer.
   The basic setup step should not be done through the installer.
3. Disable the Not null and Check constraints in the target schema.
4. Perform data import from the export dump of the production data.
5. Apply the conversion scripts for the columns with the Not null and Check constraints in the target schema to populate them with proper business data.
6. Enable the constraints in the target schema.
   The target schema will now act as the gold copy for the customer to resume the verification/ production activities.

• Advantages
  This topic explains the advantages of upgrade approach.
• Disadvantages
  This topic explains the disadvantages of upgrade approach.