Data Warehouse Questions

Data Warehouse for survey data

Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

Document templates for Data Warehouse Requirement Gathering

Hi All Is there any document template to collect the Data Warehousing Requirement Gathering. I was wondering if any one can point me to a link or sample document.

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

ETL Architecture

Hi My company is currently planning on building a datawarehouse. We are an oracle shop and are considering the approach for data migration from client servers to the datamart. Thoughts we have 1) Asynchronous CDC . I believe oracle now is replacing

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

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

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

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

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

Data Warehousing Vendors (Manufacturing)

Dear Sir or Madam We are a local company located in Syria, specialized in Industrial Confectionary Development (Food; Biscuit, Chocolate and Juice) The company seeks to find consultants/ vendors in order to initiate a data warehouseing project to be

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

Elbow to take your questions...

NME's sister magazine, Uncut, is interviewing Elbow frontman Guy Garvey for their An Audience With... feature, and they're after your questions. So, what do you ask a Mercury Prize-winning musician? Have you spent the cheque yet? What would be your

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise