Skip to main content
System StatusContact Support

Documentation related to the following products will soon be moved to a new portal: (https://docs.digital.ai/)

Digital.ai Agility, Digital.ai Agility Connect and Digital.ai Agility Integrations
Digital.ai Continuum and ALM Connect
Links from the https://community.versionone.com/ site will automatically redirect to the new site.
If you have any questions, please contact Digital.ai Support.

Digital.ai Agility Community

Dimension Types

This feature is available in Enterprise and Ultimate editions.

Dimension Types distinguish how data is stored in the dimension table. This page describes the different types of dimensions available in the VersionOne data mart

Type 1

In a Type 1 dimension, each row in the table contains the latest information from the operational system.

Key BusinessKey Name
1 1 Foo

If the asset identified with BusinessKey 1 changed names in the operational system, the data mart loader would update the existing row in the dimension with the new name. The previous name is not retained.

Key BusinessKey Name
1 1 New Name

Type 2

In a Type 2 dimension, a new row is inserted into the table when data changes in the operational system.

Key BusinessKey Name Version
1 1 Foo (Null)

If the asset identified with BusinessKey 1 changed names in the operational system, the data mart loader would add a new row to this dimension with the new name. The previous row remains the same.

Key BusinessKey Name Version
1 1 Foo 0
2 1 New Name 1

Type 3

In a Type 3 dimension, a separate column is used to represents old values.

Key BusinessKey Name Old_Name
1 1 Foo (Null)

If the asset identified with BusinessKey 1 changed names in the operational system, the data mart loader would update the existing row in the dimension with the new name. The old name is moved to a separate column and the Name column holds the current name

Key BusinessKey Name Old_Name
1 1 New Name Foo