Syncing Database Table Schemas
Reload the changes made in the database table schemas.
Procedure
- Right-click the database connection you created in and select Retrieve Schema.
-
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.