Data Warehouse Purge Strategy - HELP

Dimension Table Indexing Strategy

Please tell me what kind of indexes you are using in your dimension tables in your organization. I am looking for dimension tables indexing strategy for Sybase, Oracle and Db2. If you have any indexing strategy document for Dimension tables for

Data Warehouse - Indexes

Hi, I am currently at the point where I need to think about Indexes on my data warehouse. We are currently using SQL Server 2005. As a general rule of thumb would the following hold true (Please note that the reporting requirements are still

Purge old content Data

Well, after 6 days, Media Companion has finished scraping my movies (I have 4TB, about 5000 files). I am running the latest release of XMBC on a softmodded xbox. The original xbox scrape of my files returned some errors. Similarly named movies

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).

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

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

Watch me bust some funky moves!

Purge here, invited by Blue Toad! I'm a Space Channel 5 fangirl, and my favorite character is Purge himself! I'm not too good at Mother, I've never gotten far in the games.... Nice to meet you all!

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

World PvP Event: Undercity raid strategy!

The Spanking Phoenixes proudly present: Undercity Raid! This raid is meant to be fun for everyone (lvl70), be you PvE'er, n00b PvP'er or Wtfpwning Imba PvP'er! The goal is to kill Dark Lady Sylvanas Windrunner of Undercity! The journey