Migrating from DatabaseLookup to tHMap
If you have Jobs that use the DatabaseLookup function, you can migrate these to use the multi-input feature of tHMap.
Prerequisites
This procedure provides you an example of how you import Oracle databases to Talend Studio and create input connections to the tHMap component.
- You have a Talend Data Mapper Structure created from a database connection.
- You have a Talend Data Mapper Map, where the output element is the output of a DatabaseLookup using the database tables imported in Talend Data Mapper. See the following example:
- If you wish to use the attached sample project from the Downloads tab, you need to create databases using the sample database scripts in your local server.