You can create shadow tables
Procedure
To create a shadow table in the Data Project
Explorer view:
- Right-click a schema in the physical data model and select . The data object is created in the Data Project
Explorer, and the properties of the object open in the
Properties view.
- 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.