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. Appendix A: Naming Conventions
  11. Appendix B: Glossary

Getting Started

Getting Started

Creating the Mapping

Creating the Mapping

Create a mapping to filter out discontinued items and generate a unique ID for each row in the fact table. The mapping also finds the number of items that each customer ordered.
  1. In the Designer, switch to the Mapping Designer, and create a mapping.
  2. Name the mapping m_PromoItems.
  3. From the list of target definitions, select the tables you just created and drag them into the mapping.
  4. From the list of source definitions, add the following source definitions to the mapping:
    • PROMOTIONS
    • ITEMS_IN_PROMOTIONS
    • ITEMS
    • MANUFACTURERS
    • ORDER_ITEMS
  5. Delete all Source Qualifier transformations that the Designer creates when you add these source definitions.
  6. Add a Source Qualifier transformation named SQ_AllData to the mapping, and connect all the source definitions to it.
  7. Click
    View
    Navigator
    to close the Navigator to allow extra space in the workspace.
  8. Click
    Repository
    Save
    .

0 COMMENTS

We’d like to hear from you!