Scenario
Data is stored in a database, sometimes in massive volumes, where we . You may only need to process a tiny subset of the data. Instead of processing the entire database table, collect a small subset of the data only, based on a variable value.
Create a DB database collector to retrieve data from a database. This collector should have a "where" clause clause in it, and the . The value of that where clause - (the value being looked up, ) will be set automatically in PhixFlow.
...
- Create a database collector to load some data into a stream in PhixFlow
- Create an Input Multiplier input multiplier on that stream.
- Reference the Input Multiplier input multiplier value(s) in the collector's SQL query using the {} or {=} notation .
...