Configuring the tHMap

Create a new Job that includes the tHMap component, where you can connect the imported database tables.

1. Create a new Job.

   

2. Drag-and-drop the database tables from the Db Connections and select tOracleInput.
3. Add the following components:
   • tHMap
   • tLogRow
4. Connect the following components using the Row > Main connection:
   • tOracleInputdatabase connections to the tHMap
   • tHMap to the tLogRow
5. Enter xmlout when prompted for an output name.
6. Double-click tHMap to display the Structure Generate/Select window.
7. Select the Generate hierarchical mapper structure based on the schema option to automatically generate Structures.