OWB??™s basic set of
transformations include a name and address cleansing operator for use with Oracle
240 | Chapter 10: Oracle Data Warehousing and Business Intelligence
partners??™ libraries and applications that perform ???householding,??? matching, and
merging of data. Advanced features such as support for slowly changing dimensions
and pluggable mappings are available in the OWB Enterprise Option. The OWB
Data Quality Option includes support for data profiling and data rules.
OWB can validate the source-to-target mappings (see Figure 10-4). Once validated,
you can then generate any of the following:
??? DDL if target tables are to be created
??? SQL*Loader control files for the loading of flat files
??? PL/SQL scripts for ETL from relational sources
Scripts are deployed to and run at the target data warehouse, typically scheduled
using the Enterprise Manager job scheduler. In this way, OWB is more of an ???ELT???
tool since the transformations leverage the target database engine. For more complex
scheduling of ETL jobs where certain prerequisites must be met, OWB leverages
Oracle Workflow components.
Pages:
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530