Agile Enterprise Data Warehousing

Yesterday's design tip 111 was on agile data warehouse development I can recommend the following book on

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

New at BI and data warehousing and trying to make sense of it all.

Good evening gents! I am new on this site obviously and wanted to say hi before i start with my issue. now on to the issue. I am starting a data warehousing project from complete scratch for a small company that is getting off the ground. This is my

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,

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

Managing Data warehousing Unit

I am working as data warehousing and Reporting manager. I am responsible of managing the unit and helping my Engineers in data modeling and ETL design and developing Reporting some times .I am also responsible of running any data warehousing projects

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

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

SET1/Q.1 a. Describe the various activities involved in the selling process.

Q.1 a. Describe the various activities involved in the selling process. (8 marks) b. What do you mean by enterprise relationship? (2 marks)

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:

BF040-I50B_N09 Board to Board Connector

Hi, Can BF040-I50B_N09 (J1-J4) from base board be replaced with BF040-I50B_N15? I cannot find datasheet regarding the connector. It would be best if anyone can provide datasheet of the said connector (BF040-I50B_N15).

ETL from Oracle to SQL Server 2008 Data Warehouse

Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a