Schema Menu

Display

Refer to Displaying a Model Version for details.

Read only

Refer to Setting a Model Version as Read Only for details.

Discover

Refer to Running Discovery for details.

Profile data

Refer to Running Profiling for details.

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.
  
• Export data profiling result - Refer to Exporting Profiling Results 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 to new group - Refer to Creating a New Group for details.
  
• Add to existing group - Refer to Adding a Table to a Group for details.

Entities

Select one of the following options:

• Add entity - Refer to Adding an Entity for details.
  
• Rename multiple entities - Refer to Renaming Multiple Entities for details.
  
• Manage hidden entities - Refer to Managing Hidden Entities for details.
  
• Assign entity types - Refer to Assigning Entity Types for details.
  
• 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.
  
• 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.
  
• Trace entities source - Click to generate a schematic diagram of connected sources. Refer to Tracing Table Sources for details.
  
• Trace entities usage - Click to generate a schematic diagram of entities connected to the selected source. Refer to Tracing Table Usage 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.

Export

Select one of the following options:

• Export to WhereScapeRED - Refer to[ Exporting to WhereScapeRED

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.

Refresh

Click to refresh the schmea contents.

Rename

Click to display a dialog to let you enter a new name for the schema.

Remove from group

Refer to Removing Entities from a Group. This option is only available when working with a schema in a group.

Delete

Click to delete the schema and all the entities it contains.

Enter user documentation

Refer to Adding Details for Documentation for details.

Generate documentation

Refer to Generating Documentation for details.