Search
| Search results for : | snapshot like |
| Topics linked your research : | snapshot like |
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
Incremental Accumulating Snapshot ETL
Hi all, This is my first post here and I've searched but can't find an answer to tackle the specific problem I'm dealing with here. (I think I have a solution in part but it's pretty inelegant so wondered if there was a pattern for this problem
Underlying fact for accumulating snapshot
Hello, I'm after an accumulating snapshot fact like the following to report on how many articles in what state an author has: Author: Bob Draft Count: 2 Published Count: 10 Taken Down Count: 1 Since this is a summary table, it should ideally b
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
Fiscal Dim and Snapshot Dates for Budgets
Hi everyone, I have a couple of questions regarding fiscal dates and snapshot dates/data: 1. How would someone model a "fiscal" dim when a date maps to two fiscal months? e.g. Fiscal Year 2010 Fiscal Month 12 Fiscal Month Date
Transactional detail fact table w/complimentary snapshot table. How do the two play together?
Take a detail daily banking transaction table with standard credit and debit level transactions. I want to build the accompanying snapshot that would present the higher level rollups of these lower transactions: There are about 250 daily transaction
ETL for Accumulating Snapshot
I'm looking for a book, sql code, web links, anything to get me started on creating the ETL for an Accumulating Snapshot fact table. I've not yet been able to attend the Kimball ETL class (but the Dimensional Modeling class was great!). Does anyone
Search
