Data Warehouse for survey data

Data Marts, Conformed dimensions and Data Warehouse

Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I

SOA and Data Warehousing

Hello everyone.... I need your help here. I am working on some DW related roadmaps. I am stuck on role SOA(Service Oriented Architecture) is going to play in Data Warehousing ETL in- particular and BI in-general. Your comments on above mentioned are

Fact table for comparing survey responses (with relative weight)

Hi everyone, This is my first post on this forum, I'm glad I've found it and I hope someone could help me. Our problem is that we dont know how to design a fact table to store responses from a survey in order to compare then later. For example, we

Data Warehouse Purge Strategy - HELP

I'm looking at the best way to implement a purge strategy in a dimensional model. The reason to purge is that no personal data can be kept after 4 years, but the users would still want to see counts/facts by no identifying data. For example i couldn't

Data Warehouse Failure Statistics

Is there any recent study / statistics / surveys on data warehouse project pitfalls and risks ? Your help is truely appreciated. Best Regards,

ETL survey

Hi, I am an M.Sc. student and i am doing a small project on ETL tools and data warehousing. I just need to get some data for my primary research by whom already working on ETL/DW. so i am attaching a link of my survey page. Please reply i need this data

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Request of information: Italian softwarehouse for federated Data Warehouse

Hello, I work for an Italian financial Company that needs to reorganize the current reporting system (mainly based on Business Objects), which is made of many Data Warehouses and Datamarts in Oracle and SAP/BI. I'm interested in a federated solution

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

Kirby's Epic Yarn!

So I got this today! Everybody with a soul enjoys some Kirby every now and then. This si Kirby's first console platformer game since Kirby 64 way back in 2000, I think it was. Time flies, eh? So here is what Sparky thinks of it: First off, Toys R' Us i

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here:

New Release Media Companion gen2 3.148

Just a small update on 3.143 New feature for Movies, support for <sortorder> tags. The field is below the Movie title, by default it is the same as the title, but xbmc will list movies alphabetically according to what is in this tag. You ca