Versions Compared

Key

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

Use Input Multiplier to break up SQL IN clause into batches.

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.

...