
Chapter 7 Capturing Business Metadata from Existing Data
134
Homonyms can be resolved by using the Rosetta Stone in reverse. In the
example in Figure 7.8, the database name is required to distinguish each origi-
nating table name, since all the tables have the same name. Then the corre-
sponding new name can be associated properly. In the case of business terms, a
modifier is usually required, as in the example of revenue: Sales revenue versus
Marketing revenue.
7.3.6 Using a Staging Area
As we have seen, a lot of editing is usually required when preparing data for
entry into an enterprise metadata repository—so much editing in fact, and
rather ...