The MAP_MERGE operator is used to apply a mapper function on each row of an input table and union all intermediate results into a single result table. The operator can be a replacement for sequential FOR-loops and union patterns. In the following video, you will use the MAP_MERGE operator.