Type 2 Approach
Page 1 of 1
Type 2 Approach
we are into a bi services for insurance clients.
is it a good idea to model cascading effect on all related dimensions; when we want to achieve Type 2 across the model.
my model should answer the questions at any point back in history what is the state of policy? n what actually is the reason for some premium additions or deletion (facts) on that particular day.
is it a good idea to model cascading effect on all related dimensions; when we want to achieve Type 2 across the model.
my model should answer the questions at any point back in history what is the state of policy? n what actually is the reason for some premium additions or deletion (facts) on that particular day.
sgudavalli- Posts : 29
Join date : 2010-06-10
Age : 40
Location : Pune, India
Similar topics
» SCD type 2 approach.
» rationale behind dimension with Type 0 and missing Type 5
» Type-2 Dates as Date Data Type ?
» Advantage of this approach??
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» rationale behind dimension with Type 0 and missing Type 5
» Type-2 Dates as Date Data Type ?
» Advantage of this approach??
» Why do I need type 3 and 6 SCDs when I can implement type 7?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum