Creating shadow tables

You can create shadow tables

Procedure

To create a shadow table in the Data Project Explorer view:

  1. Right-click a schema in the physical data model and select Add Data Object > MQT. The data object is created in the Data Project Explorer, and the properties of the object open in the Properties view.
  2. On the General page of the Properties view, specify a table organization, then specify Replication in the Maintained by field.
    Restriction: Shadow tables can be either row-organized or column-organized. However, if you want to create a primary key for the table, you must set the Table organization property to Column. After you specify the correct table organization, you can specify the primary key on the Columns page of the Properties view of the table.

Feedback