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,

Preserving prior history for late arriving dimensions
Can't find much about this topic anywhere else so hopefully someone can help me. Our warehouse has late arriving dimensions for an Employee. Their department changes, for example, can be backdated in the systems and so we have to account for this and

how many dimensions is too many
If I have a fact table with too many dimensions --- over 30, does that mean I've created dimensions when they could have been attributes to another dimension table or possibly that I am trying to capture too many business processes within one fact table.

Slowly Changing Dimensions - Design Review (Need More Clarification)
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or

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

Hierarchy within single dimension or two dimensions
I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific

Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to

Kimball Dimensions
I got into a nice heated debate the other day. The item of discussion was flattened dimensions. I’d like to know your opinion (or facts) about the following, (Some of this is common sense… please still give me some feedback…). Any article citations

Modeling multiple multivalued dimensions and other design questions
Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in

Help in declaring grain and identifying dimensions
Requirements: 3 Reports ----------------------- Source Systems: 3 Project DBs 1st Report : Portfolio Summary Details The project monthly details report will display project information i.e. summary actual costs from the Vendor History file

Sandboxie's Start/run access settings
ssj100 or someone else can please explain or guiding me how to setup Sandboxie's settings Start/run access and Internet access [Restrictions].My forced programs VLC,Foxit,Firefox,WMP. Thanks

Cannot start the internet explorer...what do i do?
So I cant start ie, how do i get it working again?

Dimensions Directly Tied to Facts vs. Snowflaking
Hi all, Thanks in advance for your input on this. We are in the midst of a building out a portion of our data warehouse. The example here has to do with insurance data. Hopefully the discussion can be abstracted to a more generic modeling level. We

Date Dimensions - Muliple Calendars
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi

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