Accumulating Snap Shot Challenge

The Emu at 12h25
13
Feb
2009
Accumulating Snap Shot Challenge

Hi,

I'm working for a large Internet Service Provider (ISP) and have a DW modelling challenge which I hope people can help me out with.

Their nature of business includes as a fact recording as an accumulating daily snapshot real time partition basic session information of customers (volume for day), and is a periodic snapshot real time partitioning.

As a simplified example, the fact table includes the follow
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
I'm creating a model of our help desk ticket tracking system, and I'm not sure how to model this. We need to do a snapshot of the data because the transactional system will make overwriting updates. It's accumulating because the ticket has a lifecycle
Northern Mexico cold snap paralyzes Ciudad Juarez Freezing weather and snow paralyzed the border city of Ciudad Juarez on Friday, knocking out electricity and water in thousands of homes and closing roads and factories. Record low temperatures hit
I have a business process that has 6 distinct steps from start to conclusion for each instance of the process, we'll call it a case. Each case has two employees assigned to it, 1 owner and 1 co-owner. The owner and co-owner each have different
Yours truly has struck some gold in finding out where the next challenge is after the duel... Real World Road Rules Challenge 18 is The Pit Posted on May 11, 2009 by Michael Martin The cast left 2 weeks ago on Monday April 27th to Thailan
Is it common to update dimension keys within an accumulating snapshot fact table if it contains some slowly changing dimensions? Or is good practice to leave the keys alone and only use a more current key for new rows? My inclination is to leave the
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Accumulating Snap Shot Challenge"

This topic has been viewed 1379 times.

Last message :
13/02/2009 at 12h25 by "The Emu"