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.
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?