Perfect Dates | lonelyguysolid

New payment processor called Perfect Money

Hello There is a new payment processor called Perfect Money that is really going to be making some waves here soon in the world of E-currencies. Perfect Money is a Swiss-based payment processor that will very soon be the biggest rival of some of the

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 Dark Remake!... Sadly only for 360 :(

Well, I just learned about this... Perfect dark is getting a remake for 360! Sadly, because the Rare/Microsoft deal...Wii's missing out. Any wii only perfect dark fans pissed?

The "perfect" forum presentation

Hello everybody To help you with your forums promotion, here is how we would promote the Forumotion support forum (for example). Important : This type of presentation isn't mandatory, but we recommend you present you forum this way, because

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

SET2/Q.1 With the help of examples explain what is systematic...

Q.1 With the help of examples explain what is systematic (also called systemic) and unsystematic risk? All said and done CAPM is not perfect , do you agree?

DATE OR DATE KEYS IN FACT TABLES

I've read different opinions about the usage of dates in fact tables. If a date is NEVER used to filter and only reported, what is the purpose of adding it as a date key instead of a plain date type? Aren't we wasting the resources to get to the date

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?

Is it possible to remove dates from gallery

As above, thanks