Audit Dimensions in SQL/SSIS 2008
I've read The Micorosoft Data Warehouse Toolkit and would like to implement the audit dimension and logging set up described in that book. However, I believe the download from the book's site is for SSIS 2005. Has anyone published an updated framework for

SCD Type 2 dimension and fact table being the same table
I am designing a dimensional model for employee data in a data warehouse. Right now I only register the basic information about the employee, like job title, department, language, FTE, etc. I have chosen to use an SCD Type 2 dimension since I want to keep

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

Multivalued Dimension or Multiple facts w/conformed dimensions
I am trying to model for insurance industry, with data as follows: We have data at different levels: Policy level with related facts. ((Premium , face amount, mode etc) Policy Fund level (combination with related fact values.) Policy Rider level

KPI Goals and Percentages as Dimensions or Store as Facts?
We are using PPS Monitoring for our Dashboards and we are creating our KPIs within PPS and SSAS. Our client would like to create a dimension with these KPI goals and percentages for each goal per department and measures or add to the fact table. Now

SQL Server 2008 Date data type as dimension key
We are getting ready to migrate from Microsoft SQL Server 2005 to 2008. Currently we use an integer (in YYYYMMDD format) as the SK on our date dimension table. I am very tempted to start using the new 3-byte Date data type (which stores only the date

Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table
Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table

I'm Going To Have To Send My Next3 Back. :-(
Tonight I re-installed the Skyfire browser on my Next3. I didn't re-boot the tablet after I installed it. While I was using it for a regular page, the browser hung up. I got out of the page. Figured I should reboot the tablet so the installation would run

Bought a Tier 1 car and playing lower tracks again for fun
I got tired of playing with BMW M3 so bought myself a Mazda 3 again, bought best parts using in game cash, and started playing the lower levels again, it has been quite good fun too. I have to laugh thou as I found that a lot of lower level players are

GCC approaching from the application of the customs union
GCC approaching from the application of the customs union 06/11/2010 neighbor Kuwait, a, P, b Gulf Arab officials said Saturday that the GCC countries close to the full application of the customs union among themselves and no longer facing only

Wicked Penman ~ writing, role play, graphics, deabtes, more
A creative forum that focuses on bringing out writers, poets, graphic designers, role players, and even artists. All people with an open mind and imagination are welcome. WPM has been a work in progress, starting on a different forum software since Jul

MP Hossam Al-Azzawi: To Be For America to Take a Major Role in Arranging the Political Situation in Iraq
MP Hossam Al-Azzawi: To Be For America to Take a Major Role in Arranging the Political Situation in Iraq Conscious / Baghdad / and. X 23/1/2010 11:47 pm A member of the Iraqi Parliament Deputy Hussam al-Azzawi of the Iraqi List, States United State

Playing a Great "Social" Game
I am increasingly amused at how Lane and Enzo have brainwashed themselves into believing that they played a great social game. Did you play a great social game or were you simply likable and not considered an immediate threat? It's so easy to revise

this is hardcore:who's going?
who's going? who are you most excited for? where are you staying? GO! I'm riding with Brett, and Mike T. Possibly one more person from here. Suicide File, Floorpunch, The Rival Mob, Title Fight, Bad Seed, Trapped Under Ice, and Have heart, but

BlackBerry OS 6 features, upgrades and problems
New features of BlackBerry 6 include: * Crisp, more immersive visuals, including new graphics, animations and transitions * New WebKit browser; it’s high-fidelity and very efficient, for fast, rich browsing with support for multiple sessions