Rapidly changing Monster dimension...

Rapidly Changing Dimension

Hello, I have a slowly changing dimension table with 105 attributes. About 85% of the attributes are type 1 and the remaining 15% are type 2. I have 4 fields that are type 2 that change a lot more frequently than the rest of the type 2 fields. On a

Monster Dimensions

My customer list is huge (about 70 millionish). We currently have a 60 million row dimension (CUSTOMER) that holds most of our existing customers, and this existing large DIM is currently performing fine for us. Now my clients want to type 2 two

Monster dimension, joining fact tables

I am newbie to the DW. We have document processing OLTP system with the following tables Document table (partitioned table, approx. 1 billion rows) DocId -PK Title DocDate 10 other columns Users table UserId -PK UserName .. 3 other

Best Practices for SCD Dimension Tables for a Banking Data Warehouse

Hello, I am looking for a list of dimension tables to track historical changes on for a banking data warehouse, based on "best practices". Customer is a prime candidate. Are there others? Thanks, Ike

Type 3 Slowly Changing Dimension

I am trying to find a best example / scenario where a type 3 scd would make more sense than a type 2. In my understanding type 3 can easily be derived from type 2. If anybody has used type 3 dimension instead of type 2, please let me know the scenario an

Changing the defaul rules to your own ( PunBB template)

Changing the default rules to your own Hello, Im posting this topic here because i cant post in the "tips&tricks" section. I saw some people complaing about that they cant delete the regular agreement when registering and that they

SSIS SCD Component

We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/). We have run into a few issues and would appreciate some advice if anyone has used this SSIS

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

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

Two ways of Changing Android Keyboard on Samsung Fascinate

Method 1. To Change Android Keyboard on Samsung Fascinate Step 1. Tap the applications launcher on your Samsung Fascinate. Step 2. Scroll over and select Settings. Step 3. In the settings menu, select Language & keyboard. Step 4. Select Input

Popy's NaNoWriMo entry: (Not) Everyone is a Monster

So, as November comes, I'll be using this topic as a sort of blog of how my story is coming (anyone who doesn't know about NaNo, go here: nanowrimo.org), and even post it in full (perhaps...most likely). Here's the summary: Two groups of students awake

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

Changing the color of the profile

Err, how do I color the profile of someone when he's posting.. Err like "Administrator Posts: 24 Credits: 2000 Join date: 2011-11-29 Age: 21 Location: Space" How do I change the color of that? (This was my profile when I was posting a