Synonym Editor

Previously, using the DataMigrator capability of loading a Slowly Changing Dimension (SCD) table required identifying the SCD type of each column in the target table. This was done in the Synonym Editor one column at a time.

A new dialog box provides a quicker, simpler way for assigning the SCD types. A new panel shows all the column names and folders for each SCD type. Columns can be assigned to the appropriate type by drag-and-drop.

There are new icons in the Synonym Editor Field View that help to identify fields with types Internal and Needs Value. These field types do not allow sample data. The icons help to provide a visual indication that these fields are different.

In addition, the new Access Property column shows these values for fields with these properties. You can access this column by right-clicking the Name header in the Synonym Editor, pointing to Customize, and clicking Access Property.

The new Parameterize Value dialog box allows you to overwrite the values for the CDC attributes with the existing, corresponding, CDC variables or with new variables.

It is now simpler to edit a synonym to indicate that data should be pivoted, columns turned into rows or single column turned into multiple columns, for retrieval.

This can be done by either selecting a group of columns or a single character column that contains a delimited list of values or a JSON or XML document. A new dialog box allows specification for how the columns should be pivoted.

Also, data sources that support array structures in a field, such as Hive (for data managed by Hadoop) or MongoDB a synonym can now be created to represent an array so that the individual elements can be accessed.

When the File Listener processes remotely located files, users can now archive these files on either a local or remote system by using the new ARCHIVE_LOCAL option that is available in the File Listener Attributes.