Aggregate Tables usage

Building aggregate fact tables from staging

Hi, Is it acceptable to create an aggregate fact table from the staging tables after you have cleaned out the data in staging? I know usually you're supposed to create aggregate fact tables from the fact/dimension tables, however can it be done straigh

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

Aggregate Navigator

Does anyone know of any current Aggregate Navigator middleware products?

rollup fact table

If creating a roll up fact table would you consider using something other than the surrogate key for your date dimension join? I would not but my colleagues think we should be using month_id for example if we are creating a monthly roll up table from a

Difference between a Cube and a Star

Hello, I have a very basic question. Can anyone please, explain the difference between a cube and a star schema? I studied about Star schema. When I implement it in Oracle Warehouse Builder 11g, I have to create a cube. Am I doing right? regards,

General Rules and Guidelines

This forum provides data warehousing and business intelligence professionals with recommendations, answers, suggestions and experiences related to Kimball-oriented DW/BI best practices. Note: There may be modifications to these rules and guidelines

Tips for extending your Samsung EPIC 4G battery life

Your Samsung EPIC 4G’s battery performance is bad? Try the followings to improve your phone’s battery life. 1. Lower your Samsung EPIC 4G’s display brightness, the lower the better. 2. Use built-in task monitor to make sure you don’t have any unnecessar

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

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

DATE OR DATE KEYS IN FACT TABLES

I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date

Multiple Many-To-Many relationships

I've read quite a bit on dimensional modeling but this would be my first go in reality. Any help would be greatly appreicated. Here's what I've got... An existing subset of our DW would be: Fact_tx Dim_Customer Dim_Product One of our source

Regarding Factless Fact Tables

Some time ago I was asked to build the BI platform for a road safety organization. The warehouse was built of three primary fact tables, each with a collection of associated dimensions. I am now trying to branch out into ETL and Warehouse design, and from