Comment by Duke Ganote on Foreign Keys in a Data Mart


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:

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

Comments are closed.