Expressions can be entered using expression editor in following transformations :
- Data masking
- Update strategy
- Transaction control
Expressions can be created by following functions:
- Transformation language functions : SQL like functions
- User-defined functions : functions created by user based on transformation language functions
- Custom functions : created with custom function API
- Max number of characters 32767
- Comments can be added as — or //
- Can not run the session against a mapping with invalid expression
- Only for data mask trasformation expressions can be given in input ports also ,for all other transformations only in output ports.
- If expressions are changing frequently,parameters can be used with IsExprVar option as TRUE instead of expressions.