Page History

Data profiling result

Select one of the following options:

• Show data profiling result in graph - Refer to Viewing Profiling Result Graph for details.
• Show data profiling result in table - Refer to Viewing Profiling Result Table for details.
• Validation criteria - Refer to Validating Data Profiling by Entity, Validating Data Profiling by Attribute, and Validating Data Profiling by Relationship for details.
• Delete profiling results - Refer to Deleting Profiling Results for details.

Business rules validation

Select one of the following options:

• Validate business rules - Refer to Validating Business Rules for details.
• Show validation results - Refer to Showing Business Rule for details.
• Validation Results Export violating business rules data - Refer to Exporting Violating Business Rules Data for details.

Data transformations

Test data transformation queries - Refer to Testing Data Transformation Queries for details..

Groups

Add group - Refer to Creating a New Group for details.

Schemas

Manage Schemas - Refer to Managing Schemas for details.

Entities

Select one of the following options:

• New entity - Refer to Adding an Entity for details.
• Add predefined entity - Refer to Adding a Predefined Entity for details.
• Rename multiple entities - Refer to Renaming

• Tables for details.
• Manage hidden entities - Refer to Managing Hidden Entities for details.
• Hide empty entities - Refer to Hiding Empty Entities for details.
• Assign entity types - Refer to Assigning Entity Types for details.
• Select entities by entity type - Displays a dialog for you to select an entity type, then selects all entities of that type in the diagram.
• Add or remove entity types - Refer to Adding or Removing Entity Types for details.

Attributes

Select one of the following options:

• Rename multiple attributes - Refer to Renaming Multiple Attributes for details.
• Change multiple attributes - Refer to Changing Multiple Attributes for details.
• Manage hidden attributes - Refer to Managing Hidden Attributes for details.
• Display source data type changes - Refer to Displaying Source Data Type Changes for details.
• Derive primary keys - Refer to Primary Key Wizard for details.

Relationships

Select one of the following options:

• Derive relationships - Refer to Derive Foreign Key Joins Wizard for details.
• Delete all relationships - Refer to Deleting all Relationships within a Model Version for details.

Model

Select one of the following options:

• Apply model conversion - Refer to Applying a Model Conversion for details.
• Define model conversions - Refer to Defining Model Conversions for details.
• Trace source - Click to generate a schematic of source mappings for the source. Refer to Tracing a Source for details.
• Trace usage - Click to generate a schematic of usage from the source. Refer to Tracing Usage for details.
• Show pivot table - Refer to Creating a Pivot Table for details.
• Add source mappings - Refer to Adding Source Mappings for details.
• Remap source mappings - Refer to Remapping Source Mappings for details.
• Apply data type mapping - Refer to Applying a Data Type Mapping for details.
• Apply database function mapping - Refer to Applying a Database Function Mapping for details.
• Manage target locations - Refer to Managing Target Locations for details.
• Populate entity queries - Refer to Populate Entity Queries for details.
• Show effort calculation - Refer to Effort Calculations for details.
• Identify duplicate data - Refer to Identify Duplicate Data Wizard for details.
• Create artificial keys - Refer to Creating an Artificial Key for details.

Find

Displays the Search Function.

Paste

Refer to Copying an Entity for details.

Route all relationships

Click to redraw all the foreign key joins in the diagram.

Export

Select one of the following options:

• Export to WhereScapeRED - Refer to[ Exporting to

• WhereScape RED

• for details.
• Export to 3D XML - Refer

• to Export to 3D XML

•  for details.
• Export to specific version of XML - Refer

• to Export to specific version of XML

•  for details.
• Export 3D XML and send by email - Refer

• to Export and send by email

•  for details.
• Export to Common Warehouse Metamodel - Refer

• to Export to Common Warehouse Metamodel

•  for details.
• Export entities to CSV - Refer

• to Export entities to CSV

•  for details.
• Export sample data - Refer

• to Export sample data

•  for details.
• Generate DDL - Refer

• to Generate DDL

•  for details.

Enter user documentation

Refer to Adding Details for Documentation for details.

Generate documentation

Refer to Generating Documentation for details.