Database Join
Description
Database Join runs a parameterized SQL query against a database for each incoming row, using field values from the data stream as query parameters. Use this step when you need to enrich your data by joining it with database records based on dynamic values — for example, looking up customer details for each order row or retrieving pricing data based on product codes. Parameters are passed to the SQL query as positional placeholders (?), and the query results are appended as new fields to the output stream.
Configurations
| Field Name | Description |
|---|---|
| Step name | Specify the name of the step as it appears in the workflow workspace. This name has to be unique in a single workflow. |
| Connection | Specify the database connection to use for the query. |
| SQL | Specify the SQL query to form the join between source parameters and the database connection specified; use question marks as parameter placeholders |
| Number of rows to return | Specify the field name to store Number of rows to return. Zero (0) returns all rows; any other number limits the number of rows returned. |
| Outer join? | Enable to always return a result, even if the query did not return a result |
| Parameters table | Specify the fields containing parameters. Also specify the data type is required. |