Data Warehouse

Performance impact by using GUID instead of sequence as primary key

Is there anyone has experience on using GUID as the primary key in the data model of a huge data warehouse? What is the impact of the performance compare with the sequencial surrogate key in Oracle 10g or higher version?

how to smoke test the data warehouse?

I would like to know what kind of test should be performed to checkout the build and the test environment prior to testing?

Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit

The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

domain operational data stores vs. enterprise operational data stores

When do use a domain operational data stores rather than a enterprise operational data store?

datamart & datawarehouse

What do you mean by DATAMART & DATAWAREHOUSE & what is the difference betwen two??

Export Oracle 10g and Import to Oracle 9i

I have a data warehouse server that's running Redhat AS 2.1 and Oracle 9.2.0.4, and a production database that's running Redhat AS 4.0 and Oracle 10.2.0.3. I need to export tables from the Oracle 10g database and import them into the Oracle 9i database. The Oracle 10g server/database is new. I...

Data Warehouse vs Data Base

What is the difference between a data base and a data warehouse?

Indexing Fact Tables for a data warehouse

Hi I am reviewing the indexing the fact tables of a data warehouse and it currently has a clustered primary key and quite a few VERY LARGE covering indexes comprising lots of columns. The selectivity of the columns other than the primary key is very low; mostly close to 0% with a couple...