Converting dates to integer

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

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

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

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,

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

Combination of SCD2, partial snowflake, Effective and end dates in fact table

We are creating dataware housing for multitanant based systems for HR module. Requirement ?Able to report on historical data for any given data time. Active employees headcount till given date. (as of that day) Onhire and termination based on perticula

Iraq Important Dates

Iraq Important Dates September 10, 2010 End of Ramadan - Eid ul-Fitr Celebration September 27-28, 2010 Oil & Gas Conference Istanbul, Turkey October 8-10, 2010 IMF Conference & CBI officials/MoF Washington D.C. October 15-16, 2010 GET ENERGY

Converting Columns into Rows.

I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

ADVFN Morning Euro Markets Bulletin - Jan 11th 2011

By ADVFN.com ADVFN offer FREE streaming stocks and shares data form around the world. SEE London Market Reports Footsie back above 6,000 UK blue chips have raced away this morning led by the banks as the government caved in on the issue of

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,

Blizzard Of 2011

I live in IL. And We're Hit pretty hard. it took about an hour just to move a car 20 feet. Suppose to get 2 - 3 Feets Of Snow. O.o Anyone Else getting effected?

The Bachelorette: Jillian

The Bachelorette Gets Naughty! Will Jillian Harris morph into a female version of Jason Mesnick when The Bachelorette returns this spring? An insider tells OK! that Jillian, who finished third on The Bachelor just missing a chance to be part of singl