Deploying

The process of deploying is where database objects are actually created and PL/SQL code is actually loaded and compiled in the target database. Up until this point, no objects exist in our target schema, ACME_DWH, in our Oracle database. Everything we've talked about so far about importing metadata for tables, defining objects, mappings, and so on has referred totally to the Warehouse Builder repository, where it keeps a record of everything we've defined so far in metadata. Not a single actual database object has been created yet. Everything we've done until now has been done entirely in the OWB Design Center client. But to perform the process of deployment, now we're going to have to communicate to the target database. For that we need to be introduced to the Control center Service, which must be running for the deployments to function.

The Control Center Service

If we briefly look all the way back at Chapter 1, we talked about the architecture of the Warehouse Builder and looked...