Bottom line here is that I would create a surrogate key, but I will also let you in on a trick that we use around date keys. We define the surrogate date key to always be supplied in the numerical format of YYYYDDMM, although a true surrogate key, we can now infer meaning from this key through the use of TO_CHAR or TO_DATE functions.
Dig Deeper on Oracle database design and architecture
Related Q&A from Ian Abramson
A SearchOracle.com member asks why a low-cost query has a slower speed than expected.continue reading
A SearchOracle.com member asks, "I just rebuilt an index with 35 million rows in it. Do I have to analyze the index after rebuild?"continue reading
We are working on the development of a datamart (in 9i) which takes data from two source systems. Since this is a transaction system, there is a lot ...continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.