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 a Mapping

Creating a Mapping

In the following steps, you create a mapping and link columns in the source EMPLOYEES table to a Source Qualifier transformation.
  1. Click
    Tools
    Mapping Designer
    to open the Mapping Designer.
  2. In the Navigator, expand the Sources node in the tutorial folder, and then expand the DBD node containing the tutorial sources.
    The following image shows the contents of the Sources node in the tutorial folder:
    ""
  3. Drag the EMPLOYEES source definition into the Mapping Designer workspace.
    The Designer creates a new mapping and prompts you to provide a name.
  4. In the
    Mapping Name
    dialog box, enter m_PhoneList, and click
    OK
    .
    The recommended naming convention for mappings is m_Mappingname.
    The source definition appears in the workspace. The Designer creates a Source Qualifier transformation and connects it to the source definition.
    The following image shows the EMPLOYEES source definition and the Source Qualifier transformation:
    ""
  5. Expand the Targets node in the Navigator to open the list of all target definitions.
  6. Drag the T_EMPLOYEES target definition into the workspace.
    The target definition appears.
  7. Click
    Layout
    Arrange
    .
  8. In the
    Select Targets
    dialog box, select T_EMPLOYEES target, and click
    OK
    .
    The Designer rearranges the mapping.
The final step is to connect the Source Qualifier transformation to the target definition.

0 COMMENTS

We’d like to hear from you!