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.