Migrating the DatabaseLookup to AgConcat - 7.2

Data mapping

EnrichVersion
7.2
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
EnrichPlatform
Talend Studio
task
Data Governance > Third-party systems > Processing components (Integration) > Data mapping
Data Quality and Preparation > Third-party systems > Processing components (Integration) > Data mapping
Design and Development > Third-party systems > Processing components (Integration) > Data mapping
Now that you have successfully configured tHMap, Talend Data Mapper automatically generates a new map with multiple records that represent the database input connections.

Procedure

  1. Select tHMap to show the Input Map and Output XML panes. See that the Input pane contains the imported database tables:
  2. Use the AgConcat function to replace the DatabaseLookup function:
    1. Drag the row2 from the Input (Map) column to the AgConcat expression.
    2. Set SimpleLoop on the Loop Expression.
    3. Use the same filter values. If you have specified filter values in your Job using the DatabaseLookup function, re-use these filter values.