Create a new Job that includes the tHMap component, where you can connect the imported database tables.
Procedure
-
Create a new Job.
- Drag-and-drop the database tables from the Db Connections and select tOracleInput.
-
Add the following components:
- tHMap
- tLogRow
-
Connect the following components using the Row > Main connection:
- tOracleInputdatabase connections to the tHMap
- tHMap to the tLogRow
- Enter xmlout when prompted for an output name.
- Double-click tHMap to display the Structure Generate/Select window.
- Select the Generate hierarchical mapper structure based on the schema option to automatically generate Structures.