Load data from synonyms

You can use synonyms to create a data mart and load it with data.

A synonym is a name that you can use in place of another SQL table identifier.

The following functions are not supported for data marts that contain synonyms:
  • ifx_refreshMart()
  • ifx_setupTrickleFeed()
  • ifx_dropPartMart()
  • ifx_loadPartMart()

When you create a 1:n reference with a synonym as a parent table, you must ensure uniqueness. If the synonym references a local or remote table within the same Informix® instance, the uniqueness check is done automatically. If the synonym references a remote table on a different Informix instance, you must turn off the uniqueness checking on the use_dwa environment variable, and ensure uniqueness by other means. If you create a 1:n reference with non-unique data values in the key columns of the parent table, you get incorrect query results for queries accelerated by Informix.

If you have a query that contains a FACT directive with an alias defined for a synonym, you must use the alias name or the table name for the synonym with the FACT directive.

Query probing is not supported on queries that contain synonyms that were created on external tables of a remote database.