Comment by Duke Ganote on Foreign Keys in a Data Mart

Posted in November 28, 2008 ¬ 7:36 amh.Comments for An Expert's Guide to Oracle TechnologyComments Off

Lewis–

In my opinion:

1) every datamart should have FK, at least in RELY DISABLE NOVALIDATE state for documentation and optimization purposes.

2) As for validation… well, I’ve been experiencing a half-revolution in my thinking on this (a full revolution would be 360 degree and you’d just end up where you started).

In my prior experiences, I designed the marts and the ETL. So I knew it was done right (IMHO :) , and I relied on ETL validations in this 3-step fashion:

Data

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.

 

Array