You use the Materialized Query Tables editor to add a materialized query table.
To add a materialized query table
on the ERwin Toolbox, click in the diagram window where you want to place the table, and enter a name for the materialized query table.
The materialized query table is added to the diagram.
on the ERwin Toolbox, click the table you want to use as the source table for a materialized query table, and then click the materialized query table you created.
A relationship is created between the source table and the materialized query table. By default, the materialized query table references all columns in the source table.
in the ERwin Toolbox. Drag the table column that you want to include from the source table into the materialized query table. The materialized query column references and the associated relationship are created.
in the ERwin Toolbox, click the materialized query table you want to rename, wait a moment, and click the materialized query table again. Then, enter the new name for the materialized query table. Or, right-click a materialized query table in the Model Explorer, select Properties to open the Materialized Query Tables editor, and enter the new name in the Name box.
Note: You can add consecutive multiple materialized query tables by pressing the Ctrl key before you click the materialized query table tool. When you click again in the diagram window, another materialized query table is created.
|
Copyright © 2013 CA.
All rights reserved.
|
|