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