The Data Calculator is designed to visualize the changes applied to the data as it moves through the transformation rules. This is particularly useful to answer the question on how a change of a transformation rule would affect the outgoing data. Depending on status of the Auto-Synchronization button, a transformation rule will be immediately applied to the entire set of IN-Port records after the rule had been entered.
If Auto Synchronization is turned on, all changes of the transformation rules are applied immediately to the current set of records at the IN-Port.
To switch the current setting, click Auto-Synchronization. If Auto Synchronization is turned off you can manually trigger the processing of the IN-Port data by select the Step option.
To manually apply all transformation rules to all current records at the IN-Port, click the component Step option.
To step through the next incoming data buffer set, click Fetch the Next Set of Data.
To step through the current set of records at the IN-Port record-by-record, click the appropriate option in the record control. Or, you can select a record from the Input Port Content list.
The values shown on the Current Input Record area are changing as you change the current record.
Click the Search the Content of Transformation Rules to search for a specific keyword in the current transformation rules.
For easy identification of NULL-values and empty values, click Highlight NULL-Values and Empty Values.