1 or 2 Dimensions - Customer & Shipping Address
I have read the Toolkit book and am doing a little dimensional modelling exercise, but I have come across an issue which I am not sure about. I have a Customer dimension but I am not sure whether or not to include the shipping address in the Customer

Piano owners??
As some of you old-timers know, I've been in quartets and bands playing wind instruments (flute, clarinet, sax) and cello for years. It's my outlet, my passion, and strangely doesn't drive my head crazy with the pressure exerted with the

What game(s) are you playing at the moment?
I'm currently playing Tales of Vesperia, Eternal Sonata, and Beautiful Katamari.

Start Selenium RC server using Java
Hi All, I am able to do my tests when my Selenium RC Server is started. I am currently using command shell to start my Selenium RC Server as: java -jar selenium-server.jar. But I want to handle this part in my coding.I am using Eclipse tool. Please le

relating 2 existing dimensions combined to a fact table
given: * 1 existing sales fact table; > 1.500.000.000 records * 1 existing product dimension; >= 300.000 records * 1 existing store dimensions; >= 1.000 records required: * 3 new attributes, defined by the combination of a certain store an

Same attribute in multiple dimensions or Create new dimension?
Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

Is it possible to remove dates from gallery
As above, thanks

Conforming Dimensions - Standardising, De-duplicating and Suvivorship
Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would

System File Checker
VISTA Click Start and type in the search box: CMD and right click on Command Prompt and select Run as Administrator. In the black window type: sfc /scannow and press enter. It will finish itself within 5-30 minutes, or longer. When it finishes, it

What about the technicans tell us BEFORE they start "fixing"/gambling
Okay, I'm pissed off at the moment like many others here. That I don't write in capslock is just because I'm not facing someone in real! I pay for some services of forumotion, and even on those forums I run on basic level I "pay" while have ads

Database Partitioning and Dimensions without the distribution key
We are upgrading our data warehouse platform, and now have the option to partition the database across CPUs as well as partitioning tables themselves. For database partitioning, there is a performance impact if the data from tables to be joined is not

A fact table surrounded by a lot of references tables
I am reviewing a design which is about to be implemented after build. There is a fact table with 17(!!) foreign keys. 14 of these keys are two-letter codes pointing to reference-tables (as we call them). A reference table consist of codes with

How to manage Conformed dimensions
Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

Unsure about relationship with Slowly Changing dimensions.
Hi Sorry datawarehouse newbie question! I have many years experience with relational databases but my head is not yet around the dimensional model. I am not sure how to maintain the relationship between Fact and Type 2 Dimension. i.e if a new row is

Best Praticte for inserting fact and linking to dimensions
Hi all, is it allowed to have null values in fact table for some dimensions foreign keys ? Exemple : DateDimFk DimFk1 DimFk2 50 (coming from business system 1) DateDimFk null DimFk2 50 (coming from business system 2) or do i have to create a