When you add a materialized query table to a model, the materialized query table appears in the model as a box with rounded corners. A relationship between a table and a materialized query table indicates that the materialized query table references one or more of the columns from that table.
A materialized query column can be a reference to a table column or a user-defined expression.
When you draw a relationship between a table and a materialized query table, none of the columns in the table migrate to the materialized query table. By default, the <MaterializedQueryColumnName> is the same as the <SourceColumnName> until you edit the materialized query column name.
You can edit materialized query tables directly in the diagram window using on-diagram editing. When you drag a column from a table into a materialized query table, the materialized query column and the relationship are created.
If you delete a table column that is referenced by a materialized query table, the corresponding materialized query column is also deleted. If you delete a table that is referenced by a materialized query table, the corresponding materialized query columns are deleted.
|
Copyright © 2017 erwin Inc.
All rights reserved.
|
|