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