Rapidly Changing Dimension

Rapidly changing Monster dimension...

Hi Everyone, I have a list of more than 300 attributes, which are actually part of the fact table.(basically ..these values changes for each transaction level record in fact but belongs to a single dimension). that lot contains more than a 100 date

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

fast changing dimension

I'm debating how to model a teacher work force where most often a teacher works for one school authority. The issue is where a teacher works for multiple school authorities. A substitute teacher for example could work for a different school authority ever

Loading Fact Table with Type 2 Slowly Changing Dimension

I'm new to data warehousing .. sorry if this is a basic question. I have a type 2 slowly changing dimension already loaded and now I want to load a fact table. At least, I think it should be a fact table. A lot of the entities in the dimension table

Slowly Changing Dimension table

Hello, I have scenario where we are creating a Dimension Table and Fact Table from the same Source Table which contains both descriptive and numeric data I want to model the Dimension table as a Slowly changing Dimension Type 2 (create new

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

Changing the name color

So, my friend joined my forum and she get's into two groups that are both "Color team members" the first is black and the other is white so my friend's name is black. Her name appears black and she wants it to be white, how do I do that?

fact table as a dimension

Hi I'm presently modeling a data mart and I would like to use a fact table as a dimension for another fact table. Is it something doable and efficient or is there a better way to do that? if yes should i just create a surrogate key and link both

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