Default Model Conversions

3NF to Star Schema

Converts the 3rd Normal Form system model into a Star Schema with Facts, Dimensions, Surrogate keys and data lineage. By default, relies on the model being in a category (e.g. Physical) that contains an entity type of "Fact source" where the user will assign this entity type to entities that represent a "Fact" entity, usually the entities with the largest row count or several measuring attributes.

• Recommended Usage - Transitioning from "Physical" category to "Star schema" category.
• Where to From here - Apply model conversion "Generate Load and Stage tables".

3NF to Star Schema Views

Converts 3rd Normal Form tables into Dimensional star schema implemented via database views, often used for presentation layer virtualization. Similar to the purpose and behavior of the model conversion "3NF to Star Schema". The end result of the transformation results in the Facts and Dimensions to be Views.

• Recommended Usage - Transitioning from "Physical" category to "Star schema" category.
• Where to From here - Apply model conversion "Generate Load and Stage tables".

Create artificial keys

Transforms business relationships in a Star Schema model by copying the surrogate key attributes into the Fact Tables with an index and an artificial key relationship to the Dimension's surrogate key attribute.

• Recommended Usage - In the workflow of a "Star schema" category. Safe to re-apply.

Generate Load and Stage tables

Transforms a Star Schema model to generate the Stage and Load entities required for processing data and applying soft business rules.

• Recommended usage - Transitioning from "Star Schema" category to "Load and Stage" category.
• Where to from here - Run the Prepare for RED wizard.

ws3d_grv - Logical to DV Spine

This model conversion generates the Hubs and Links from a Data Vault design model. It contains templates that contain the use of attribute type "Link business key"

ws3d_grv - Create satellites

Template model conversion that is used by the wizard workflow to create all Satellites for the Raw Data Vault from a Data Vault design model.

ws3d_grv - Hash Key generation

This model conversion generates the Hash key flavor for the Raw Vault. It contains templates that contain the use of entity type "Hub" and attribute type "Business key"

ws3d_rvls - Create initial stages

This model conversion creates the temporary Stage entities from all Hubs, Links and Satellites. It contains templates that contain the use of attribute types "Business key", "Hub hash key" and "Link dependent child".

ws3d_rvls - Define change hashes on satellite stages

This model conversion renames the change hashes for Satellites and define the information required for WhereScape RED.

ws3d_rvls - Define extended properties for hub and link hash key

This model conversion defines the information on the hash keys for Satellites that is required for WhereScape RED.

ws3d_rvls - Merge and clean up stages

This model conversion merges the temporary Stage entities into their final forms and bringing together the Satellites to their relevant Hubs and Links.

ws3d_rvls - Create loads

This model conversion creates the Load entities from all Stage entities.

ws3d_rvls - Housekeeping

This model conversion tidies up any attribute properties that don't need to be sent to WhereScape RED.

ws3d_gbv - Create Satellite View Layer

Generates two layers of views for each Satellite:

• The current view only returns the latest record from Satellite.
• PIT view adds dss_end_date and dss_current_flag to ease downstream when querying a specific record in history.

ws3d_gbv - PIT Tables from Views

Business Vault model conversion used to generate PIT table(s) from current and historical satellite views in model and Entity Type – PIT Candidate.

ws3d_gbv - Generate Bridge tables

Business Vault model conversion to generate Bridge tables from Entity Type - Bridge Candidate.

ws3d_gbv - final modifications

Business Vault model conversion for Business Vault final steps for PIT and Bridge tables.

config_gbv - Assign Targets

Business Vault model conversion to assign Bridge, PIT and views to business vault target if it exists.

ws3d_bvls - Prep Model

Business Vault Deployment model conversion to get category ready for RED Export like Load and Staging for Data Vault.

WhereScape RED Export Preparation

This model conversion prepares the model for importing into WhereScape RED. It will fix naming and add the record source data transformation.