Defining a Target Module

Defining a Target Module

In this lesson you will learn how to define a target module, also called an Oracle warehouse module.

Topics

This lesson will discuss the following:

Overview
Prerequisites
Create a Warehouse Module
Summary

This lesson will take approximately 20 minutes to complete.

Move your mouse over this icon to show all screenshots. You can also move your mouse over each individual icon to see only the screenshot associated with it.


Overview

In this lesson, you will learn how to create a target module. Creating a Target Module is simple and similar to defining source modules. Warehouse modules contain definitions to build your warehouse. Warehouse Builder stores the definitions for your target schema in warehouse modules.

Back to Topic List

Back to Topic List

In order for this lesson to work successfully, you will need to have performed the following:

1.

Completed Overview lesson.

2.

Completed Logging in to OWB lesson

 

Create a Warehouse Module

Back to Topic List

The Target module that you will create will eventually be used to store object definitions.

1.

In the OWB10g_DEMO project, expand Databases, right click the Oracle node. Select Create Oracle Module.

Move your mouse over this icon to see the image

 

2.

Click Next on the New Module Wizard: Welcome Page. The New Module Wizard: Name page appears. Name the module DQ_TEST. Select Warehouse Target as the module type. Click Next.

Move your mouse over this icon to see the image

 

 

3.

The New Module Wizard: Connection Information page appears. On this page you provide information needed to import metadata.

Select Oracle Data Dictionary to import metadata from an Oracle database.

The Database Link information is needed only if you want to import metadata into the warehouse module. Leave the Database Link field empty, as you are not importing any data definitions. Click Next.

Move your mouse over this icon to see the image

 

4.

The New Module Wizard: Location page is displayed. On this page you create a new location or choose from a drop-down list of previously specified locations.

Locations define information about the database schema or target tool where you will be deploying objects.

For this lesson you will not create a new location. Instead, from the drop-down list select the predefined location TARGET_LOC. Click Next.

Move your mouse over this icon to see the image

 

5.

The New Module Wizard: Finish page is displayed. Review the definitions you created.

Move your mouse over this icon to see the image

 

 

6.

Click Finish. Warehouse Builder added the target module DQ_TEST under the Databases node.

Move your mouse over this icon to see the image

In the OWB10g_DEMO project, expand DQ_TEST. You will notice there are many object definitions you can create in the context of a target module:

Mapping
Transformations
Dimensions
Cubes
Tables
Views
Materialized Views
External Tables
Advanced Queues
Sequences

 

 

Summary

Back to Topic List

You are now able to create a target module. Warehouse Builder stores definition for the target schemas in the target warehouse module.

 

 

 

 

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy