Real Time DW

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

What I mean with real time DW here is: when the source system is updated, within few seconds that change is reflected in the DW. Generally speaking there are 3 ways to achieve this:

1) using a normalized data model,

2) using a dimensional data model and

3) keep the data in the source system.

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful