Copy the database preparation scripts from the BIL assets
and run them.
About this task
To run the database preparation scripts:
Procedure
- Navigate to the SCRIPTS/DataBase directory
in your BIL assets.
- Copy the scripts specific to your database type: DB2® or Oracle.
- Modify each script to provide information that is unique
to your implementation, such as schema names.
- Run each Alter and Drop script.
Note: Each script
is independent from the others, so the order in which they are run
is not important. It is, however, important that each script is run.
What to do next
If your implementation requires history to be stored,
you will have to recreate the history triggers after finishing the
BIL data load. To complete this task, use the Create Triggers script
provided with InfoSphere® MDM.