Connect CDC (SQData) provides a facility in which user defined variables can be used within an Apply Engine script. By using variables, you have the ability to perform additional manipulation on source field/columns. Variables can also be used for enhanced process control by setting flags, establishing and incrementing counters, etc.
Connect CDC (SQData) manages user-defined variables in a Variable Pool. The values in user-defined variables can be accessed by simply naming them as you would any source field. Precisely highly recommends adopting a naming standard for variables so they can be easily identified and distinguished from source and target fields. Applying a prefix, such as (V_) to every user-defined variable is a common practice. The value of a variable can be set in the same manner as a target field. Each variable must be explicitly defined within the Variable Pool using the DECLARE command.