As the behaviour of two databases transactional and Data warehouse database is different. As a DBA what do you think there should be difference in init.ora parameter for overall database performanc...
http://www.experts-exchange.com/Database/Oracle/Q_20752561.html
Zones:
OracleDate Answered: 09/21/2004 Grade: A Views: 0
Hello Experts!
I'm quite newbie about databases. Would anybody explain me what is the difference between a DataMart and a Datawarehouse ? Is it the same?
Thank you!
http://www.experts-exchange.com/Database/Miscellaneous/Q_20757259.html
Zones:
DatabasesDate Answered: 10/04/2003 Grade: A Views: 8
Thanks in advance! Sorry but i don't have more than 95 points.
We are having a situation (PROBLEM) with our DW - SQL SERVER 2000 SP4 ENT X86, it suddenly slowed a lot.
CPU Usage : 20%
IO :...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23290951.html
For dimension tables, what is the generally accepted way to track changes in the tables so that I can use them for a Slowly Changing Dimension. IMO, there are a few options.
1. Use the SCD W...
http://www.experts-exchange.com/Database/OLAP/Q_23308031.html
Hello,
I need to install a datawarehouse sql server 2005.
The company are going to implement the database and they ask about 500GB storage for their database(s).
We are using netapp storage an...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_2300...
