Building aggregate fact tables from staging

Does it belong in the stage tables or fact tables?

If I have a fact table with a "counter" fact, for example a customer places an order, but then goes back and changes parts of that order any number of times, I want to store how many times the customer changed his/her order. The grain of the

Understanding Materialized Views as aggregate tables

Hello I have to provide a count and I am using a materialized view in sql 2008 as an aggregate table. My issue is understanding how the count will work. I need a count by 3 different categories (Product, Type, and TypeName). So....should that field be

How long should -1 dummy records exist in fact tables?

Dear Kimball Group, we are using the Kimball BUS Architecture method with SQL Server 2005, SSIS, SSAS, ProClarity, PPS, and MOSS. I am at a clients site that is using Full Refresh process for building 3 data marts so far every night. We are trying to

Aggregate Tables usage

We are building a datawarehouse and it has been proposed to contain both detail and aggregate tables, with the aggregate tables at the month level and detail at the daily level. I do understand that aggregate tables are done to gain at the performance

Primary Key of Dimension and Fact Tables

I've seen several people give presentations which purport to represent the Kimball Method and I've seen this done two ways. What is the current position on what should be the primary key of a dimension table? I was under the impression that we

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

Fact table with multiple date ?

Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Cash Cow: Building An Online Empire

Choice of the category: Computers & Internet Choice of a title: Cash Cow: Building An Online Empire Forum address: http://cashcow.forumotion.com/ Main language: English Forum description: Have you been trying to make money online and

1983 Suzuki GR650 Tempter Cafe Racer Project

This is my 1983 Suzuki GR 650 Tempter X. It was a piece of junk when I purchased it for 250 bucks. It is still a work in progress for sure but ill get there. I have plans to remove all the blinkers and add custom taillights.

Volume and Weight in Same Fact Table

Is it appropriate to include two facts that are not of the same type? In my example, I may need to have both Volume (Gallons) and Weight (Pounds) in the same fact table. I am building a DW around products that we recycle, these products can be Oil or

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise