Load data from views

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

The columns contained in the views must consist of data types that are supported by Informix® Warehouse Accelerator, including JSON collections. For example, you can create a view that uses functions that are not supported natively by Informix Warehouse Accelerator, if the columns that are output in the projection list are data types that are supported by Informix Warehouse Accelerator.

Views are a projection of a SELECT statement, which can have joins.

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

If the parent table is a view, you must turn off the uniqueness checking on the use_dwa environment variable, and ensure uniqueness by other means.

Queries that are to be accelerated by using a data mart that contains views, must also use the views.