In an Expression transformation, macro input fields define the constants to use in the expression. %IncomeMin% defines the low end of each salary range and %IncomeMax% defines the high end of each salary range. %EmployeeType% lists the job category that corresponds to each range.

The EmployeeStatus transformation output field passes the results to the mapping and includes the following horizontal macro expression:

%OPR_IIF[ (EMP_SALARY>=%IncomeMin%) AND (EMP_SALARY<%IncomeMax%), %EmployeeType%, 'unknown' ]%

In the Target transformation, the default field rule includes the EmployeeStatus transformation output field in the incoming fields list. In the target field mapping, the EmployeeStatus is mapped to the target.

The following image shows the horizontal macro in an Expression transformation:

The horizontal macro expression expands as follows when you run the task:

IIF(Salary>=5000 AND Salary<50000), 'IndividualContributor',
  IIF (Salary>=50000 AND Salary<100000), 'Manager',
    IIF (Salary>=100000 AND Salary<150000), 'SeniorManager', 'unknown')))

Note that the expression uses the first value of each macro input field in the first IIF expression and continues with each subsequent set of constants.