This video provides demo on how to configure a horizontal expression macro with business usecase, using Informatica cloud mapping designer.
In general 'expression macro' is a macro that you use to create repetitive or complex expressions in mappings.
Horizontal expression macro, expands the horizontal expansion function for a given input macro field.