...

• Create and use static Streams
• Create and use static pipes

Anchor
_Toc442889192 _Toc442889192

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 should see that the data in SOURCE_CHANNEL_LIST is loaded, including the channel description looked up from SOURCE_CHANNEL_DESCRIPTIONS.
However, look at the Stream Sets for SOURCE_CHANNEL_DESCRIPTIONS to see that it has only run once. Compare the run dates with the Stream Sets in SOURCE_CHANNEL_LIST. You will see that SOURCE_CHANNEL_DESCRIPTIONS was not run when you ran SOURCE_CHANNEL_LIST; SOURCE_CHANNEL_DESCRIPTIONS only ran when you ran it on its own.

Anchor
_Toc442889193 _Toc442889193

Create and use a static pipe

• Hover over SOURCE_CHANNEL_LIST and press 
• Call the new stream Customer Channel Copy
• Copy all attributes from SOURCE_CHANNEL_LIST to Customer Channel Copy
• Hover over the pipe and press
• Run Analysis on Customer Channel Copy

...