Database Lookup Functions - 6.3

Talend Data Mapper User Guide

Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Design and Development
Talend Studio

The database lookup functions allow a value of a single column for a single row to be looked up based on a specified condition. The DatabaseLookup returns a value and is read only. The DatabaseLookupAndUpdate is used to do a database update at the same time. This is used for the common case of processing a row and then updating a value indicating the row has been processed.

The database lookup functions can be used whether or not you read and write database tables.