Scenario
Data enrichment via a DB lookup may use a SQL "IN" clause, but sometimes the number of values in the IN clause exceeds the number of values allowed in a single IN clause by the database. In that case, it becomes necessary to break up the values in the IN clause into separate blocks so that the database can process them.
...
- Create a database collector to load some data into a stream in PhixFlow
- Create an Input Multiplier on that stream in PhixFlow
- Configue the input multiplier to compile the Ids from this stream into 2 separate Input Multiplier elements (lists) for use in an IN clause in the DB collector