Relationnal integrity in a DW

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Thu, 30 Nov 2000 01:07:34 -0800 (PST)
Message-Id: <10696.123293@fatcity.com>

Hi,

In a previous DW project (Oracle 8.0.5) , I've used constraints between the fact and the dimension tables because we had developped the ETL tool ourselves.

On this project, we're using Informatica Powermart. I can always set the constraints to no novalidate and disable and only use the rely option but I'm a bit reluctant not to have the db controlling the data integrity.

How do you manage the constraints in your DW (Oracle 8.1.6)

TIA

---

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

---

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/ Received on Thu Nov 30 2000 - 03:07:34 CST