Previous |
Next |
The orphan management policy in OWB enables you to manage orphan records in dimensions and cubes. An orphan record is one that does not have a corresponding, existing parent record.
Orphan records can occur when:
A record that is loaded into a dimensional object does not have a corresponding parent record.
A record is deleted from a dimensional object. This could result in the child records of the deleted record not having an existing parent record.
OWB enables you to specify a different orphan management policy for loading dimensional data and removing dimensional data.
|
See Also: "Orphan Management for Dimensional Objects" under Overview of Cubes in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide |