Data Warehouse Questions and Answers

Recent IT Questions

1 - 8 of 8
<<PREVIOUS 1 NEXT>>

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?

Answer Question   |  Jan 6 2009  6:46 PM GMT
GUID, Data Model Primary Key, Data warehouse
asked by Jzliao

  5 pts.

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?

Answer Question   |  Oct 4 2008  2:47 AM GMT
Data warehousing applications, Data warehouse
asked by Ktkn

  5 pts.

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?

View Answer   |  May 21 2008  4:35 PM GMT
64 bit architecture, ETL, Data warehouse
asked by Jmc

  5 pts.

domain operational data stores vs. enterprise operational data stores

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

Answer Question   |  May 7 2008  7:52 PM GMT
Data warehouse, ODS (Operational Data Store)
asked by Alisonnelson

  5 pts.

datamart & datawarehouse

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

View Answer   |  Mar 21 2008  7:06 AM GMT
Database Management Systems, Data mart, Data warehouse
asked by Pratap123

  15 pts.

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

View Answer   |  Mar 17 2008  7:36 PM GMT
Red Hat Enterprise Linux, Oracle 10, Data warehouse
asked by Llewis

  5 pts.

Data Warehouse vs Data Base

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

View Answer   |  Jan 10 2008  1:40 AM GMT
Data base design, Data warehouse
asked by Gayle

  5 pts.

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

View Answer   |  Nov 6 2007  1:17 AM GMT
SQL Server 2005, Data warehouse
asked by Garp

  0 pts.

1 - 8 of 8
<<PREVIOUS 1 NEXT>>