IICS:Expression Horizontal Macros with Constants

#iics #etlguru #etl
IICS: Expression Horizontal Macros with Constants

Horizontal macro with constant example
------------------------------------------------------------------
To create categories for employees based on salary ranges, you might create a horizontal macro that defines the minimum and maximum values for each range and corresponding job categories.

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.

For the details description and DML,DDL Statements used in this demo Please Refer the link
------------------------------------------------------------------------------------------------------------------
https://docs.google.com/document/d/1v...