alternate approaches for late arriving dimension attributes
2 posters
Page 1 of 1
alternate approaches for late arriving dimension attributes
I have a scenario where I have more than one late arriving dimension attribute (eg : status, interest type etc) in a type 2 dimension and the effective date (which is retroactive) of these attributes could be different from each other and its possible both can arrive late on the same load. Since the effective and expiry date in this dimension applies to the entire record, how to manage different effective dates for these attributes in this case? Is it OK to separate these attributes in to another child dimension similar to the creating a new dim for rapidly changing dim attributes? Even this may not solve due to different effective dates. Appreciate any help or insights to resolve this.
karthiksm- Posts : 2
Join date : 2013-10-20
Re: alternate approaches for late arriving dimension attributes
There is a lot you need to consider:
How late is late? Given this is a type 2, what about the facts already loaded? Do they need to be rekeyed?
How different are the timestamps of these attributes? Seconds, minutes, hours, days? What really makes sense from a business point of view? Do small differences really matter? Its one thing to be technically accurate, but does it really matter?
How late is late? Given this is a type 2, what about the facts already loaded? Do they need to be rekeyed?
How different are the timestamps of these attributes? Seconds, minutes, hours, days? What really makes sense from a business point of view? Do small differences really matter? Its one thing to be technically accurate, but does it really matter?
Similar topics
» Late Arriving Dimension Data
» Large number of late arriving facts
» Design Alternatives for Late Arriving/Updated Type 2 Dimension Data
» Late Arriving Facts
» Part of fact information arives later
» Large number of late arriving facts
» Design Alternatives for Late Arriving/Updated Type 2 Dimension Data
» Late Arriving Facts
» Part of fact information arives later
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum