Table of Contents


  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  17. Datatype Reference
  18. Configure the Web Browser

Working with Mappings

Working with Mappings

You can complete the following tasks with mappings:
  • Create a mapping.
    When you create a mapping, you save the mapping name in the repository. You can then develop and save the mapping.
  • Open a mapping.
    You can open one mapping at a time in a folder.
  • Copy a mapping.
    You can copy a mapping within the same folder or to another folder.
  • Copy a mapping segment.
    You can copy segments of mappings and mapplets when you want to reuse a portion of the mapping logic.
  • Copy objects in a mapping.
    You can copy one or more objects in a mapping and paste them into another mapping or mapplet in the same folder.
  • Export a mapping.
    You can export a mapping to an XML file.
  • Import a mapping.
    You can import a mapping from an XML file that you exported in the Designer.
  • Edit a mapping.
    You can add, modify, or delete objects in a mapping.
  • Save a mapping.
    When you save a mapping in the repository, the Designer performs mapping validation.
  • Debug a mapping.
    Run the Debugger in the Mapping Designer to test mapping logic.
  • Delete a mapping.
    Delete a mapping from the repository if you do not want to use it again.
  • View link paths to a port.
    You can view link paths to a port in a mapping. You can view the forward path, the backward path, or both.
  • View source column dependencies.
    You can view from which source columns a target column receives data.
  • Connect objects in a mapping.
    You can connect objects in a mapping to define the flow of data from sources to targets.
  • Link ports.
    You can connect mapping objects by linking ports manually or automatically by name or position.
  • Propagate port attributes.
    You can propagate port attributes in a mapping. You can propagate attributes forward, backward, or in both directions.

Updated June 25, 2018