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)
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 : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
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
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
In reading a previous thread, I understand that when a Dimension is changed by a SCD type 2, a new record is created for the new key and no update is needed on the previously existing facts.
However, what happens in the loading of the fact table that
it is a real time clock that auto adjust daylight savings and does the time zone that your comp is set to. if you want to use it...either gimme a hexdecimal color code for teh bg color. or show me where you are gonna put it so i can match it up.
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
Search
Informations
1 Replies For the topic :
"Real Time Data Aggregation"
This topic has been viewed 2012 times.
Last message :
09/02/2010 at 17h01 by "asridhar7"






