Improving data quality at the source can sometimes be accomplished by not allowing
a ???default??? condition as allowable input into a data field. Presenting the data-entry person
with an array of valid options, one of which must be selected, is often a way to
ensure the most consistent and valid responses. Many companies also provide education
to the data-entry people, showing them how the data they??™re keying in will be used
and what the significance of it is.
Other Software for the Data Warehouse | 239
Simple extraction and transportation of data is possible using one of several Oracle
database features:
Transparent Gateways and Heterogeneous Services
Provide a bridge to retrieve data from non-Oracle sources using Oracle SQL to
load an Oracle database. Heterogeneous Services provide ODBC connectivity to
non-Oracle relational sources. Gateways can optionally provide a higher level of
performance when extracting data from non-Oracle sources.
Transportable Tablespaces
Another feature for data movement, Transportable Tablespaces enable rapid
data movement between Oracle instances without export/import.
Pages:
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527