Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Read the contents of both tables into CenterViewPhixFlow. As in the previous exercise, you will see that there are 15 sales orders, and 100 phone numbers.
You will now add a Merge Stream to build a list of sales orders, enriched with phone numbers:

...

Where you are dealing with very large data sets and are using a configuration like this – enrichment through a Merge where the main input pipe is a Mandatory Multiplier, it is often useful to use the Execute Strategy option to optimise performance. See the CenterView PhixFlow help for more details.

Anchor
_Ref354150494
_Ref354150494
Anchor
_Toc442889259
_Toc442889259
Enrichment using merge with multiplier pipe from external table

...

This is an important configuration and is commonly used to enrich a large data set in CenterView PhixFlow from a very large external table.