FastChangeCoTM's data modelers keep experiencing the problem of lost mappings from views to tables in PowerDesigner.
How can repeating tasks be simplified? The question of automating processes in a data warehouse (DWH) keeps project teams busy.
One of my most successful blog posts, the article on generating large sample data with the TPC-H benchmark, receives an update.
Change Data Capture detects changes to data. In the case of deleted data, the question is: How should we manage deletions in Data Vault?
There's a question that comes up in every workshop sooner or later: "Do we really need this complexity?" What people mean is bitemporal historization – two timelines instead of one, a few more columns, more logic when loading. It's a fair question.
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.
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?
Page 3 of 13