Tables Page
The Tables Tab provides the ability to view the available source tables as well as see the status of the last run synchronizations.
Some functions use icons. See the
Icon Glossary for more information.
Tables List
The tables list displays information about all the tables available as source tables. Tables in the database specified as the Default Target database will not be listed. Below is a description of each column in the table:
More|Less Chevron - If a row has more information than the available display space, you can use the "more" and "less" chevron to expand/collapse the additional information.
Selection Checkbox - The row selection checkbox applies to the Duplicate, Import, Export, and Sync functions. Click the checkbox next to each row you wish to do an operation against.
Status - The status column will contain either a green success icon or a red error icon depending on whether the last time the transform was run was successful or resulted in an error. If the status shows an error, clicking on the "more" chevron will expand the row and display the error text.
Catalog - This is the name of the catalog the table is in.
Owner - This is the owner name for the table.
Item Name - This is the name of the table.
Sync Type - Displays the type of synchronization from the last time the table was synchronized. Possible types are
Automatic,
Full,
Incremental,
Incremental Only,
Baseline, or
Savepoint.
Start - Timestamp displaying the starting date and time.
Duration - The duration in hours, minutes and seconds (
hh:mm:ss)
Rows - Number of rows affected by the operation.
Inserted - Number of rows inserted by the operation.
Updated - Number of rows updated by the operation.
Deleted - Number of rows deleted by the operation.
Search Filter
This button activates search fields for the Status, Catalog, Owner and Item Name fields. To filter the results in the list oftables, enter a value in one or more of these search fields.
For example, entering the word EMPLOYEES in the Item Name search box will display only the tasks that have the word EMPLOYEES in Item Name.
Sync button
To perform an on demand sync, select a table/tables by clicking the selection checkbox next to the table/tables you want to sync and press the
Sync button. This starts the synchronization process on the selected tables. The view will switch to the
Overview Summary Tab where you will be able to monitor the progress.
To perform this synchronization on a regular basis, you can create a schedule. To create a schedule, go to the
Schedules tab. See
Designing a Schedule for more information.
For more information about On Demand Synchronization, see
Synchronizing Tables to Target Destination.
Refresh Button
The refresh button refreshes the list of tables.