cmingmon (7/29/2011)

---

There are currently 6 different servers, 6 instances, and 6 databases. Each instance/database are on its own server. The task is to consolidate the 6 databases into 1 to...

Little confused... there are six Oracle "instances" each one running a "database" or there is one Oracle instance with six operational "schemas" each one of them equating one "database"?

ian.scrivens (7/28/2011)

---

I am in the process of designing a DW (something I have no prior experience of), part of which will contain client data.

This client data will be fed from...

rashu5577 (7/29/2011)

---

I am very new to Oracle, I am planning to take some classes for Oracle 10G DBA.

But I am getting confused like which is good whether MS SQL Server...

Anthony Robinson (7/19/2011)

---

Are there any "real" advantages to utilizing a named query to populate a dimension versus using an actual table? From my perspective, I can see te advanteages of...

Sqlraider (7/25/2011)

---

I am just getting into creating Dimension/Fact tables from our data warehouse using SQL Server 2008 R2, SSIS, & SSAS.

I currently have the following books:

The Data Warehouse ETL Toolkit...

Sachin Vaidya (7/20/2011)

---

I want to read the data from a oracle db table into a sql server db table. I heard that this can be done by setting up a...

Check backups......

David Portas (7/18/2011)

---

PaulB-TheOneAndOnly (7/17/2011)

---

A proper, complex, enterprise level Data Warehouse is nothing but a collection of simple Datamarts that share some conformed dimensions therefore there is not limit in regards...

shanghaigirl-1125377 (7/16/2011)

---

my assumption is if the same query runs on the same environment same table structure (one with slightly less records in my case) same indexes should return same execution...

David Portas (7/13/2011)

---

Dimensional models are most often used for simple data marts with a few entities. In a larger, more complex enterprise data warehouse it may only be feasible to...

If you are not planning to enforce Referential Integrity...

kramaswamy (7/15/2011)

---

primary keys are the physical structuring of the table. any query against the table will always use the primary key, unless there is a covering index which can supply...

I was actually referring to the actual Oracle Documentation Library... every single book ever published by Oracle, all free and...

rnoakhali (7/15/2011)

---

...So I am lil bit afraid to start learning Oracle. Can anyone tell me how much effort should I give to learn Oracle?

If I start studying 3 hours each...