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
  16. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Mapplets Overview

Mapplets Overview

A mapplet is a reusable object that you create in the Mapplet Designer. It contains a set of transformations and lets you reuse the transformation logic in multiple mappings.
For example, if you have several fact tables that require a series of dimension keys, you can create a mapplet containing a series of Lookup transformations to find each dimension key. You can then use the mapplet in each fact table mapping, rather than recreate the same lookup logic in each mapping.
When you use a mapplet in a mapping, you use an instance of the mapplet. Like a reusable transformation, any change made to the mapplet is inherited by all instances of the mapplet.
Mapplets help simplify mappings in the following ways:
  • Include source definitions.
    Use multiple source definitions and source qualifiers to provide source data for a mapping.
  • Accept data from sources in a mapping.
    If you want the mapplet to receive data from the mapping, use an Input transformation to receive source data.
  • Include multiple transformations.
    A mapplet can contain as many transformations as you need.
  • Pass data to multiple transformations.
    You can create a mapplet to feed data to multiple transformations. Each Output transformation in a mapplet represents one output group in a mapplet.
  • Contain unused ports.
    You do not have to connect all mapplet input and output ports in a mapping.

Updated March 29, 2021