Dynamic input works by reading data from a database at runtime and selectively retrieving records based on criteria determined by an incoming data stream. It essentially allows you to filter database table content on the fly, returning only data that matches specific parameters derived from the initial input. This dynamically chosen data is then joined with the original data stream.
Here's a breakdown of the process:
-
Incoming Data Stream: A data stream enters the dynamic input process. This stream contains the criteria used to filter the database.
-
Database Connection: The dynamic input tool connects to a specified database.
-
Dynamic Filtering: The incoming data stream provides the filter criteria, which are then applied to the database table. This filtering determines which records are selected.
-
Data Retrieval: Only the database records that meet the specified filter criteria are retrieved.
-
Data Joining: The retrieved data from the database is joined with the original incoming data stream, creating a combined data set.
In essence, the Dynamic Input tool dynamically controls which records are read from a database based on the incoming data, providing a flexible way to tailor database queries based on real-time data input. This is particularly useful when you need to retrieve different subsets of data from a database depending on the context of your workflow.
