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

Nod32 User & Password here: (daily updated)
July 05, 2008 UserName: EAV-03994124 PassWord: fubhtbd4wh UserName: EAV-03991824 PassWord: wpk5n7uhuv UserName: EAV-03990626 PassWord: jxmd7r3tmt UserName: EAV-03968943 PassWord: skc2few7s6 UserName: EAV-03734811 PassWord:

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

Hello
Greetings, everyone. You may know me on several sites as Darth Thrax, Damon Revus, Chris Kilgannon, and Devrin Coheed.

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

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

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,

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,

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

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