Staging transformations
for adapters that are supported by MXG create additional tables that
are MXG views for each of the staged tables that are targets of the
transformation. The views enable you to use the staged tables because
you can use the names of tables and columns as MXG traditionally names
them. Thus, views provide compatibility with any of your existing
programs that might use MXG tables. These tables are identified in
the metadata by the prefix MXG_Staged_.
By default, the views
are stored in the same library as the staged tables that are associated
with the views.
The MXG views are defined
or updated in metadata each time an MXG staging transformation is
saved, if there are eligible tables supported by MXG that are associated
with it. When the job is executed, the physical views are created
or re-created.