|
|
matching data elements, 56-57
defined, 56
problems, 56-57
structural, 57
See also data elements
merge synonyms, 187
merge tables, 207
horizontal, 209
multiple, 211
vertical, 209
See also tables
metadata
as data profiling input, 124-126
as data profiling output, 129
judging, 154
matching, to discovered properties, 154
on column-level layout, 125
verification, 139
metadata repositories, 19
domains, 145
failures, 19
as new frontier, 64
poor quality data in, 54
in primary/foreign key pairs identification, 200
in structure analysis, 189
synonym candidates in, 199
methodologies, 18
metrics, 82-85
benefits, 82-83
comparing, 83
drawbacks, 83-85
examples, 82
for qualification, 82-83
as shock factor, 84-85
uses, 82-83
moving/restructuring data, 52-62
in cause investigation, 92-93
data cleansing, 59-60
with ETL processes, 52
extraction, 58-59
integration, 62
loading, 61
matching, 56-57
overloaded fields and, 55-56
problems, 53
projects requiring, 54
reasons, 52-53
steps, 62
tools, 52
transforms, 60
See also inaccurate data sources
multiple conflicting rules, 164
multiple-source tables, 211
|
|