• TEDAMOH

    Blog

PowerDesigner is currently only available for the Windows operating system. So far, so familiar. Amal Leyla Qasim, a data modeler on the Data Management Center of Excellence (DMCE) team, has set her sights on switching her workstation to an Apple MacBook Air.

Data Vault Dimension-Ids

Resilient and temporally correct dimension Id’s for fact as well as dimension tables

In a dimensional data model based on a Data Vault data model, are integer values still necessary as dimension Id’s? And if so, how can the dimension Id’s be provided correctly?

TEDAMOH - Secret Spice Data Vault timeline - Picture by Parrish Freeman on Unsplash

Does the Load Date Timestamp (LDTS) data element in the hub, link, or satellite capture the timestamp of the batch, or rather the transaction timestamp at which the data originated in the operational system?

5th anniversary of TEDAMOH

Dear readers of my blog,

five years ago a long cherished idea of mine became reality. On July 1, 2017, TEDAMOH saw the light of day.

Last week I had the opportunity to present online at the Data Vault User Group about temporal data: Who, how, what - why bitemporal data? Who does not ask will not be wise!

In several projects, FastChangeCo's data modelers on the Data Management Center of Excellence (DMCE) team had an issue with the way PowerDesigner generates comments for tables and columns for the SQL Server database. Xuefang Kaya (one of the data modelers on the team), asked about the problems, says to the DMCE team:

Our roundtable in Frankfurt in March started with a bang:

Marketing for BI is even lower in the priority order than documentation.