Synonym Enhancements

In this section:

The following features are enhancements to working with synonyms in the DataMigrator Console.


Top of page

x
Warning for a Synonym With No Key Columns Identified

When a synonym is created without any key columns identified, a warning message is displayed. Keys should be identified because not having keys can cause a table to load slowly.


Top of page

x
ACCEPT Values in a Synonym for Table Log Records

Reference:

The Sample Data dialog box for a log records table synonym now shows a list of options for the &&CDC_START parameter.



x
Reference: Sample Data

When you request sample data for a log table, a dialog box opens so that you can supply values to override the parameters in the synonym.

Sample Data

For example, you can sample data from a log table without creating a checkpoint by checking the check box in front of &&CDC_CHKPT_SAVE and entering the value NO.

You can also specify where to start reading the log by specifying a value for &&CDC_START. The values are the same as those specified in the synonym.


Top of page

x
Show/Modify Data Tools for a Synonym

Show/Modify Data is a new option in the Data Management context menu available from the DMC or Web Console, which allows you to view data for a selected synonym in a grid format, one page at a time. The data displayed can be filtered based on the value of one or more fields, and the fields to be displayed can be customized. Data values can also be edited for synonyms for relational database sources. New values can be added for both relational and file data sources.


Top of page

x
Add FTP Connection Name to a Synonym for FIX and DFIX

A synonym that was created based on a remote connection (not local) for a delimited or fixed format file now has a CONNECTION attribute that is displayed in the Synonym Editor.


WebFOCUS