Getting Started

10.5.1
- 10.5
- 10.4.0

Back Next

Creating Targets

Before you create a mapping, you need to create the target tables for the mapping. These instructions explain how to create the following target tables:

F_PROMO_ITEMS. A fact table of promotional items.

D_ITEMS, D_PROMOTIONS, and D_MANUFACTURERS. Dimensional tables.

Open the Designer, connect to the repository, and open the tutorial folder.

Click

Tools

Target Designer

To clear the workspace, right-click the workspace, and select

Clear All

Click

Targets

Create

In the

Create Target Table

dialog box, enter F_PROMO_ITEMS as the name of the target table, select the database type, and click

Create

Repeat step Creating Targets to create the other tables needed for this schema: D_ITEMS, D_PROMOTIONS, and D_MANUFACTURERS. When you have created all these tables, click

Done

Open each target definition, and add the columns to the appropriate table.

The following table describes the columns for the table D_ITEMS
:

Column	Datatype	Precision	Not Null	Key
ITEM_ID	Integer	-	Not Null	Primary Key
ITEM_NAME	Varchar	72	-	-
PRICE	Money	default	-	-

The following table describes the columns for the table
D_PROMOTIONS
:

Column	Datatype	Precision	Not Null	Key
PROMOTION_ID	Integer	-	Not Null	Primary Key
PROMOTION_NAME	Varchar	72	-	-
DESCRIPTION	Varchar	default	-	-
START_DATE	Datetime	default	-	-
END_DATE	Datetime	default	-	-

The following table describes the columns for the table D_MANUFACTURERS
:

Column	Datatype	Precision	Not Null	Key
MANUFACTURER_ID	Integer	-	Not Null	Primary Key
MANUFACTURER_NAME	Varchar	72	-	-

The following table describes the columns for the table F_PROMO_ITEMS
:

Column	Datatype	Precision	Not Null	Key
PROMO_ITEM_ID	Integer	-	Not Null	Primary Key
FK_ITEM_ID	Integer	-	-	Foreign Key
FK_PROMOTION_ID	Integer	-	-	Foreign Key
FK_MANUFACTURER_ID	Integer	-	-	Foreign Key
NUMBER_ORDERED	Integer	-	-	-
DISCOUNT	Money	default	-	-
COMMENTS	Varchar	default	-	-