Real Time Data Aggregation

asridhar7 at 17h01
09
Feb
2010
Real Time Data Aggregation

i would like get some inputs, best practices around populating Periodic aggregation and Accumulated Aggregation tables from Real Time Data Source (PowerExchange)
About
This topic belongs to the forum
  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Hey, There is a lot of buzz going on regarding real time datawarehousing. But how do you actually do this ? How can you implement conformed dimensions and conformed facts in real time ? How can you consolidate data real time ? Vendors promise
We have transactions that occur in multiple time zones, but store in the DW all in one common format (EST) -- BI displays the time appropriately by location OR by user. We are building an aggregated fact table -- aggregating by date. We don't want to
Hi, As I was reading through articles I came across one of the advantages in real time datawarehouse that it can replace the operational reporting so there is no need for reports to go across 2 reporting DB there can be one centralised Real time DW so
This example has two facts, each w/ several dimensions: 1) Customer - date created, etc. 2) Purchases - purchase date, price, etc. Customer grain = individual customer and Purchase grain = one product purchased. I want to setup my data model/schema
we should be able to have real time notifications like facebook does so we can know straight away when someone replied to our post or added us as a friend.
Forums from same category
See also
more_less
Informations

1 Replies For the topic :
"Real Time Data Aggregation"

This topic has been viewed 2003 times.

Last message :
09/02/2010 at 17h01 by "asridhar7"