Syncing Database Table Schemas
Reload the changes made in the database table schemas.
Procedure
- Right-click the database connection you created in Retrieve Schema. and select
-
Double-click the database output component,
tOracleOutput, in the Job to display the
Component tab.
- Select Edit Schema.
- Sync the columns accordingly.
-
Go to the Mapping view and access
.
- Right-click on the database you created.
- Select [Re]Load Table Definitions.
-
Access
.
- Select the appropriate Job.
- Right-click on the tHMap and select Synchronize with Structures.