Table of Contents

Search

  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

Designer Guide

Designer Guide

Evaluating Expressions Using Mapping Variables

Evaluating Expressions Using Mapping Variables

If you define variables in the mapping, you can evaluate the start value or current value of the mapping variable. To find the start value of a mapping variable, evaluate the mapping variable only.
The Debugger uses the following process to determine the start value of a mapping variable:
  1. Parameter file.
    If you use a parameter file, the Debugger returns the value in the parameter file.
  2. Repository.
    If you do not use a parameter file, the Debugger returns the value in the repository.
  3. Initial value.
    If the repository does not have a stored value for the variable, the Debugger returns the initial value configured in the mapping variable.
  4. Default value.
    If you do not configure an initial value for the mapping variable, the Debugger returns the default value based on datatypes.
To find the current value of a mapping variable, evaluate the mapping variable with one of the variable functions, such as SetMaxVariable or SetCountVariable. The Designer displays only the mapping variables associated with the transformations in the mapping. To view mapping variables associated with a mapplet, select the transformation within the expanded mapplet when the Debugger is running.

0 COMMENTS

We’d like to hear from you!