By the end of this chapter you will be able to:

• Create and use static Streamsstreams
• Create and use static pipes

...

Create and use a static Stream

• Create a model Static Streams and Pipes
• Drag the datasource CRM onto the model
• From this datasource, find the table SOURCE_CHANNEL_LIST – create a database collector and stream to read this table into PhixFlow
• Create a database collector and stream to read data from the table SOURCE_CHANNEL_DESCRIPTIONS into PhixFlow

You will use the Stream SOURCE_CHANNEL_DESCRIPTIONS as reference data – to look up the description for each channel listed in SOURCE_CHANNEL_LIST:

• Hover over SOURCE_CHANNEL_DESCRIPTIONS and press
• Run Analysis on SOURCE_CHANNEL_DESCRIPTIONS to load data into the Stream
• Add a lookup pipe from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
• Complete configuration of the pipe:
  • Call the pipe desc

  • Create a match:

    Left-hand (reference data - SOURCE_CHANNEL_LIST)	Right-hand (output - SOURCE_CHANNEL_LIST)
    CHANNEL	CHANNEL

    
    

• Drag the Attribute CHANNEL_DESC from SOURCE_CHANNEL_DESCRIPTIONS to SOURCE_CHANNEL_LIST
• Run Analysis on SOURCE_CHANNEL_LIST

...