Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?
Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?

Remedy for a Bridge Table?
Hi folks, I'm looking to get rid of my bridge table. (yes I know why whould I want to do that?) Reason being that I am using Mondrian and as far as I can tell bridge tables don't fit. My Situation: I have many facts and many Participants each

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

Gome Flytouch ePad Work in Progress
Specs: MODEL: NAB7800ATP VIS: 7 inch 800x480 Color TFT touch panel screen HDMI: No HD: No VIDEO: FLV 400x240p AUDIO: Stereo and 3.5mm connector MIC: Yes CAM: Yes / Video CAM MODE: 802.11(b,g,n) TX/RX:150/300 FREG: 2.4GHz Battery: Lithium Ion

Aggregated Date Dimension
In my dimensional model, I have a Date dimension that plays many different roles in multiple fact tables. I will also have a fact table that store metrics aggregated at the Month level and one that stores metrics aggregated at the Quarter level. How

Work-arounds for issues with stock Rooted Nook Color ROM
I thought I would include a list of tips for the Nook. I had experienced several of these during the rooting of my nook so I thought it woud be worth while to share some of these that I found by Will Shanklin 1. How do I keep wifi from turning of

Selenim RC stuck when running a test suit via eclipse and Ant
Hi, I am currently trying to run some automation tests via selenium with testing thru eclipse, i start the test via an Ant . So I have my test suite in tesNG.xml as follows DOCTYPE suite SYSTEM "http://testng.org/testng-1.0.dtd">

FAH GPU Tracker V2 Setup Guide
The purpose of this guide is to properly setup FAH GPU Tracker V2. The guide will cover the basic settings. 1. Download FAH GPU Tracker V2: 3.34 Stable 2. Extract the folder. You can put FAH GPU Tracker V2 in any folder, and move it anytime without

many to many relationship between dimension level
I need help to design dimension model. Detail of Dimension are as following: Dimension : Student, School Fact : Grade 1. Class_Year 2. School 3. Area 4. City Analysis Requirement are to drill up /down by above given hierarchy there is : M:1

Specify acceptable Snowflaking scenarios
Can someone please specify acceptable snowflaking scenarios. - Thanks in advance bi_at_nj

Static Facts on Dimension Table?
I have basic dimensional modeling question. I would like to know if anyone can cite issues with putting a static fact on a dimension table vs. putting it on a fact table. The example I'll use is that of an 'asset' dimension table and a 'month-end'

SCD type 2 - Valid To Date Value? 12/31/9999 or Null?
Hello all, While populating Effective End Date (Valid to date) for current record, is it better to put a largest possible end date value of 12/31/9999, or is it better to insert a null value. One advantage of inserting 12/31/9999 as end date is that

Surrogate Key causing incorrect results
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications

Advice on relationships between Type 2 SCDs ?
Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of

Indicator Dimension or Fact Table
Sorry, this is a long explanation but I wanted to document the entire “case”. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a