New Online Permission Artist - Chris Scalf
I think I found a new Online Permission artist tonight. His name is Chris Scalf and here's the link to some of his images: http://www.chrisscalf.com/Sci%20Fi%20Portfolio/SciFi%20Html/scifi%20portfolio.html And here's the link to his

Fact table type
Basic questions about fact table type in kimball methodologies. Would appreciate if someone could explain 1)Transactional fact table type This is the transaction event captured from source OLTP system. Fact table in this case has all the keys instead

Fiscal Dim and Snapshot Dates for Budgets
Hi everyone, I have a couple of questions regarding fiscal dates and snapshot dates/data: 1. How would someone model a "fiscal" dim when a date maps to two fiscal months? e.g. Fiscal Year 2010 Fiscal Month 12 Fiscal Month Date

Converting dates to integer
I am in the process of building a datawarehouse. The OLTP has dates like "date_enforced", "date_entered" in the datetime format. How do I convert this to integer in SSIS since my date dimension has the datekey as integer in the YYYYMMD

Dealing with empty/missing dates in dimensions
I'd like to know other people's opinions on how to deal with missing dates in dimensions, which is a situation that happens quite frequently (for example, think of birth date in a customer dimension). We all know that attributes in dimensions should not

Perfect Dates
As the title says, how would you describe a perfect date... with or without the nasty

January 10th Perfect Future, Great Eastern Dream, Chris Lynch, Enzuigiri
Great Eastern Dream - Holy shit. Seriously, that set was incredible. Even with the amp problem, that didn't matter. Very impressive. Perfect Future - YES! Besides a few sloppy moments, fucking great. Drummer put dents in my snare head. Chris Lynch

US & Canada Tour Dates!!
Taken from the official Elbow facebook page: Quote:It's the news you've all been waiting for - Elbow have just confirmed a string of dates across the U.S.A. and Canada. This autumn the band will be playing shows in Atlanta, Washington, New York,

Null value for dates
All of my dimension tables have a value -1 that means there was no match to then dimension table. I try to put in some value such as "Unknown" or "Not available". Any suggestions for the -1 row in a Date dimension? Should I use some future date suc

Pulp Live dates
For the first time in 15 years, the classic Pulp lineup will re-form to play shows including London's Wireless festival and Spain's Primavera Sound. From the Guardian I would be so up for this. If it is anything like last year's Blur reunion gigs,

zodiac updated so hard
http://rah.posterous.com/new-zodiac-sign-2012 i'm now tauros SO HARD

ETL approach for replacing multiple dates in one row.
We have a Fact table that stores several key dates in the life cycle of a customer. Each of these dates is supposed to be a surrogate key pointing to the date dimension. My questions pertains to efficiently replacing these dates with surrogate keys in the

Updated IMDB scraper library - 09-October-2010
Just replace the imdb.dll file in your Media Companion folder with the one contained within the download archive. IMDB made some pretty big changes this time, pretty much had to rewrite every parameter. It seems that IMDB is being rather clever in

Hedge Fund Industry Performance
[quote="batman"]December effect Bodes well for Hedge funds...I like this piece. Solid research...I also enjoy the 2010 outlook for funds... Hedge fund advisory firm the Hennessee Group believes the equity markets are likely to continue

Fact table with multiple date ?
Hi, I am modling a fact table for prisoners inscription in order to track historical changes. An admission is the hole stay comprise of one or many inscriptions usually separated by transferts between institutions. In the transactionnal system, it