Periodic snapshots - what is better?

kmorasoabi at 17h13
19
Mar
2009
Periodic snapshots - what is better?

Apologize in advance for a lengthy but general query – I hope there is an expert who has done this many times that can help me.

We need to build a periodic snapshot table in our data warehouse. This is an example of a bank that needs to store account balances for every account for each of its millions of customers. On a daily basis, only about 10% of the accounts have any activity (transactions) on them, for the rest, the balance rem

Read more
Reply
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
Updating Periodic Snapshot Fact Tables
What are the best practices for maintaining periodic snapshot fact tables if the atomic data that created them is modified? We have a couple periodic snapshot tables that capture new inventory and new revenue at the end of every month. Sometimes the
How to Track SCD Type 2 for Accumlating or Periodic Snapshot
Hi, I am looking to create a Periodic Snapshot fact and Accumulating snapshot fact for Backlog of orders and order completion. I tried searching in this forum as to how to model this scenario SCD type 2, but unable to find any. If I have to carry over
Large Fact Table and Maintaining Periodic Snapshot: Practice
I would like some opinions with my approach here. I am trying to replace an overkill lift and load ETL process that basically replicated the entire universe of dataset every period instead of doing just Delta Load. In this delta approach, I have a stage
Variable period data in a single periodic snapshot fact table
I have to load account information into a periodic snapshot table which is at a day level. I have three different sources that provide the interest rates and balances information. Two of those sources(A and B) process interest rates and balances only on
Terosu Clan [Element(periodic table) manipulation]
Name: Terosu Founder: Terosu Omnisomu Location: Kumogakure mostly History: The Terosu clan was a group of nomads, wandering around the village of Kumogakure no Sato, who practiced strange arts of worshiping the earth, almost as if they were druids.
Forums from same category
Informations

7 Replies For the topic :
"Periodic snapshots - what is better?"

This topic has been viewed 1538 times.

Last message :
19/03/2009 at 17h13 by "kmorasoabi"