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.