The Model Conversion Rules are summarized in the following table. Click the link to access further details about each model conversion rule.
Rule | Description |
---|---|
Copies the surrogate attribute from the PK entity into the FK entity of each matched relationship. Generates an index for the created attribute. | |
Creates an attribute in each matched entity. | |
Adds an extended property to an attribute. | |
Copies matched attributes into matched entities based on the entity's source mappings. Optionally removes attribute types from and/or assigns attribute types to the copied attributes. | |
Adds a data transformation for each matched attribute to each matched entity. | |
Creates an entity with zero or more attributes. | |
Adds an extended property to an attribute. | |
Creates relationships between the matched attribute pairs in the matched entity pairs. | |
Copies any missing relationships that exist between the source entities of the matched entities, and optionally assigns relationship types to them. | |
Creates source mappings for attributes in the matched entities from the matched relationships. Optionally removes the relationships, effectively converting the relationship to a source mapping. | |
Applies data type mappings over the given model. | |
Change the attribute types assigned to the matched attributes. | |
Assigns entities to the group. | |
Changes the entity types assigned to the matched entities. | |
Set the query template for matched entities. | |
Change the relationship types assigned to the matched relationships. | |
Set the schema for all matched entities. | |
Assigns a target location to all matched entities. | |
Modifies the properties of an attribute. | |
Change the entity icon of all matched entities. | |
This rule modifies the properties of an entity. There is a single property that hides or unhides the entity now. | |
For each matched entity, copies the source mapping(s) from the sourced entity or attribute's source mapping to the specified depth, or removes all source mappings from the entity. | |
For each matched entity, the rule converts the casing of the value in each of the selected fields to upper or lower case. | |
Converts the matched entity subtype relationships to either a relational relationship or by merging of the parents and their subtypes. | |
For each matched entity, duplicate matched attribute within the entity. | |
Copies matched attributes from one entity to another. | |
Creates copies of all matched entities and allows keeping or redirecting their source mapping lineage. | |
Creates a group for the model and assigns the matched entities to it. | |
Creates an index on each matched entity. | |
Creates a view for each matched entity, and either creates source mappings from the view to the entity or replaces the entity with the view. | |
Deletes the matched attribute's extended properties in each matched attribute. | |
Deletes the matched attribute source mappings from each matched attribute. | |
Deletes all matched attributes from each matched entity. | |
Deletes the data transformations on the matched attributes of each matched entity. | |
Deletes all matched entities and optionally all foreign key attributes referencing them. | |
Deletes the matched entity's extended properties in each matched entity. | |
Deletes the matched entity source mappings on each matched entity. Does not affect the attribute source mappings. | |
Deletes a group from the model. Name of the group is defined using a template. | |
Deletes all matched indexes on each matched entity. | |
Deletes all matched relationships between any matched FK entity and any matched PK entity. | |
Deletes all matched source sets on each matched entity. | |
Removes the schema from all matched entities. | |
Renames entity or attribute names or labels to a defined business standard. | |
Enables you to flip the direction of a matched relationship. | |
Run and apply a DDL template against a matched entity. | |
For each matched relationship, merge the PK and FK entities together. | |
Merge all matched entities that share similar source mappings into a single entity. | |
Merge all matched entities into a single entity. | |
Enables you to handle merging multiple source mapping sets within a matched entity. | |
Generates a query or DW query for each matched entity. | |
Change the source mappings on each matched attribute, either to align with the source mappings on the entity, or to point to a matched attribute in the same source system. | |
Change the source mappings on each matched entity, either to align with the source mappings on the attributes in the entity, or to point to a matched entity in the same source system. | |
Removes entities from the group. | |
Changes the matched attributes' names or labels. | |
Change the matched entities' names or labels. | |
Renames a group for the model. Name of the group is defined using a template. | |
Renames the schema on each matched entity. | |
For each matched entity, this rule changes the order that its attributes are presented. | |
A rule used to support separating, grouping or specifying a description of the next set of rules. | |
Sets the comment of the matched attributes. | |
Enables you to define user documentation for an attribute on any matched subjects. | |
Sets the comment of the matched entity. | |
Enables you to define user documentation for an entity on any matched subjects. | |
Allows the values of load table properties to be manipulated. | |
Allows query join types to be set. | |
Enables you to add a comment to a relationship. | |
Enables you to define user documentation for a relationship on any matched subjects. | |
Splits each matched entity into two moving the matched attributes to the new entity. The new entity has a relationship to the original it has an attribute with the PK property set. | |
Similar to the Split Entities rule, this Advanced version combines multiple Split Entities rules that have the same matching and general entity creation properties, while allowing the user to define each new entity's moved attributes. | |
Splits each matched entity into; an entity with attributes that have no source mappings; and an entity for each sourced entity with the attributes that have source mappings to that entity. | |
Enables you to split entities by their source mapping sets. | |
Converts each matched relationship into an aggregate entity that has copies of the attributes that the original relationship was between and creates relationships between these attributes and the original relationship attributes. | |
Uses a template to validate the state of models. |