Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Creating Targets

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.
  1. Open the Designer, connect to the repository, and open the tutorial folder.
  2. Click
    Tools
    Target Designer
    .
    To clear the workspace, right-click the workspace, and select
    Clear All
    .
  3. Click
    Targets
    Create
    .
  4. 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
    .
  5. 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
    .
  6. 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
    -
    -
    The datatypes may vary, depending on the database you choose.
    For F_PROMO_ITEMS, you include foreign key columns that correspond to the primary keys in each of the dimension tables.
  7. Click
    OK.
  8. Click
    Repository
    Save
    .

0 COMMENTS

We’d like to hear from you!