When the Debugger pauses, use the Expression Editor to evaluate expressions using mapping variables and ports in a selected transformation.
You can evaluate expressions in the following transformations:
When you create an expression, you use references to ports within the transformation. The Expression Editor does not display ports for other transformations in the mapping. When you evaluate the expression, the Debugger returns the result of the expression in a message box.
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:
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.
Steps to Evaluate Expressions
To evaluate an expression while the Debugger pauses, complete the following steps:
To evaluate an expression while the Debugger pauses:
If the expression is valid, the Integration Service evaluates it. The Integration Service returns the result of the expression in a message box.
Using The Designer
Working With Sources
Working With Flat Files
Working With Targets
Mapping Parameters And Variables
Working With User-defined Functions
Using The Debugger
Viewing Data Lineage
Managing Business Components
Creating Cubes And Dimensions
Using The Mapping Wizards
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.