This video provides demo on how to configure a vertical 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.​

Vertical expression macro, expands the output macro expression vertically to selected input row.