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?
This time, FastChangeCoTM's Data Management Center of Excellence (DMCE) team looks at the question: what are the business requirements for bitemporal data?
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.
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?
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:
At FastChangeCo, the data modelers within the Data Management Center of Excellence (DMCE) team are constantly designing new database objects to store data. One of the data modelers on the team is Xuefang Kaya. When she takes a new user story/task, she usually models multiple tables, their columns, and specifies a data type for each column.
Page 1 of 2