The Supertype Subtype Identity transformation can be applied on an existing subtype relationship in a logical model. When you create or resolve a Supertype Subtype Identity transformation, the identifying relationships are preserved and the subtype symbol is deleted. No attribute or column is affected by the transformation. The preserved identifying relationships are exposed in both the logical and physical model.
To create an identifying relationship between a supertype and subtype entity with a transformation
The Supertype/Subtype Identity icon becomes active on the Transformations toolbar.
The subtype relationships are converted to identifying relationships.
Copyright © 2013 CA.
All rights reserved.
|
|