The Aggregation transformation
might create an additional table that contains MXG views under the
following conditions:
-
the input (source) table to the
Aggregation transformation is a staged table supported by MXG
-
the Aggregation transformation
creates at least one simple aggregation table
The view is created
for the first such simple aggregation table. These tables are identified
in the metadata by the prefix MXG_Simple_.
By default, the view
is stored in the same library as the simple table associated with
the view.
MXG views are defined
or updated in the metadata each time an MXG Aggregation transformation
is saved, if the preceding conditions are met. When the job is executed,
the physical view is created or re-created.