Database Lookup Functions - 6.3

Talend Data Mapper User Guide

EnrichVersion
6.3
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
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.