Database Reference
In-Depth Information
To complete the Property Characteristics Template, enter the name for each property in the
Property column (you can copy and paste from the Property Template). Then add the defin-
ition. I usually like to see a definition that is at least a few sentences long. I know the tem-
plate doesn't leave much room for text, but in a landscape format you will have more room.
If you think it would be beneficial to show some sample values, you can add those too. I of-
ten find with codes, such as
Country Code
, that it makes sense to add a few sample values.
Format can be date, character, integer, etc., and the Length is how long the data element
is. Optionally, you can include where the property comes from (the Source column) and
any Transformations that might be required to bring data from the source into this prop-
erty. Transformations are useful to capture for derived properties such as for
Gross Sales
Amount
.
For Relational
Recall our relational CDM from
Chapter 5
:
