7.3 Expression Mapping
Expression mappings use formulas or expressions to transform source business terms into equivalent target business terms. There are 10 Expression Mappings.
Example:
- Source: Leg Type Code in PBSMCS
- Target: Leg Type Code (Expression) in DFCS
- Transformation logic
(expression):
CASE WHEN [Leg Type] = 1 THEN 'PAY' WHEN [Leg Type] = 2 THEN 'RCV' ELSE 'NDER' END