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 Pass-Through Mapping

Creating a Pass-Through Mapping

In the previous lesson, you added source and target definitions to the repository. You also generated and ran the SQL code to create target tables.
The next step is to create a mapping to depict the flow of data between sources and targets. For this step, you create a pass-through mapping. A pass-through mapping inserts all the source rows into the target.
To create and edit mappings, you use the Mapping Designer tool in the Designer. You add transformations to a mapping that depict how the Integration Service extracts and transforms data before it loads a target.
The following figure shows a mapping between a source and a target with a Source Qualifier transformation:
""
  1. Output port
  2. Input/Output port
  3. Input port
The source qualifier represents the rows that the Integration Service reads from the source when it runs a session.
If you examine the mapping, you see that data flows from the source definition to the Source Qualifier transformation to the target definition through a series of input and output ports.
The source provides information, so it contains only output ports, one for each column. Each output port is connected to a corresponding input port in the Source Qualifier transformation. The Source Qualifier transformation contains both input and output ports. The target contains input ports.
When you design mappings that contain different types of transformations, you can configure transformation ports as inputs, outputs, or both. You can rename ports and change the datatypes.

0 COMMENTS

We’d like to hear from you!