Reviewing the Source and Destination Table Details

Verify the source and destination table details in the Tables tab.

Note: The information that appears on the Tables tab for file sources is different from the information that appears when using a database source.

The Tables tab shows all the tables or files from the datasource along with the destination table names to which each source is mapped. By default, the destination table names are the same as the source table or extracted from file names. You can enter or select a different destination table name.

If you have enabled Replication Server materialization in the Source tab, you cannot change the name of the destination table, which is the same as the source table with INSERT_RS as a suffix.

For the file datasource, all files that match a file pattern, by default, are loaded into the same destination table. To change this behavior, you can split the file pattern in the Tables tab.

Note: File patterns do not work for HTTP and FTP.

Perform these tasks on the database or file source type, and the destination tables:

For database sources, click the Add a Query Source icon on the toolbar to add a query source to perform a transformation on the source data before it is loaded into Sybase IQ. Manually enter a SQL query in the Edit Query Source dialog, select lookup source tables and attributes, or open the Query Designer to draw the query and automatically generate the SQL statement. The default destination table name is the same as the name of the query source.
To delete a query, right-click an existing source query entry in the Transfer table and select Delete Query.
To edit a query, click the Edit Query icon next to the query in the Source column.
Click the Automatically Refresh when Source or Destination Definitions Change icon to refresh the list automatically each time the source or destination connection details change. If the source type changes, the list is refreshed, regardless of the state of this icon.
By default, this icon is set to "on" for all new project and "off" when opening an existing project.
Click the Include All Objects in Transfer icon or Exclude All Objects from Transfer icon on the toolbar to select or unselect all tables for transfer. By default, all tables are selected for transfer. You can also select or unselect the Transfer option for each table individually.
Click the Mark All Transferring Objects for Truncation icon or Mark No Transferring Objects for Truncation icon to select or unselect all destination tables for truncation before loading. By default, all selected destination tables are selected to be truncated before loading. You can also select or unselect the Truncate option for each table individually.

Note: Destination tables can only be marked for truncation if the source table is selected for transfer.
Click the Create Missing Destination Tables icon to create destination tables that do not yet exist on the destination database. See Create Missing Destination Tables.
Click the Truncate all Destination Tables icon. Truncation and loading of destination tables occur in separate transactions.
Click the Drop all Destination Tables icon. To truncate or drop the destination tables of a selected table, right-click the table row and select Truncate Table or Drop Table.
Click the Count the Records in all Sources icon to count and retrieve the records in all of the selected source tables, views and queries and display it in the Source Count column. Alternatively, right-click the table name and select Count Source. This functionality is only available if the source type is a database source.
Click the Select Rows Containing a String or Regular Expression icon to search for and select entries that match a GLOB or a Java regular expression. This is useful for selecting all tables that match a pattern and removing them from transfer.
Specify a filter condition in the Source Filter field to filter the table entries based on the Source column values. Table entries that are not displayed, but were marked for transfer, continue to be loaded into Sybase IQ during execution. If you click Transfer All, Transfer None, Truncate All, and Truncate None, when a Source Filter is defined, only the settings of the visible rows are changed.

Note: GLOB and regular expressions are not supported as filter conditions.
Right-click a row and select Load to perform a test load of selected tables with a specified number of records.
Right-click a row and select Browse Source to view source table or query data. This functionality is not available for file datasource.

Note: If a destination table does not exist, an error icon appears in the Destination Table column of a table entry. To fix this, you can manually enter a destination table name of an existing table, select a destination table by clicking the Table icon in the respective column, or create the missing tables by clicking the Create Missing Destination Tables icon on the toolbar. If a connection to the destination database is not made, a question mark (?) appears in the Destination Table column of each entry.