OWB - Referential Rule

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

Referential Rule permit to enforce referential integrity.

3 - Referential Rule

When you create a rule and you select the type referential, the software will ask you to enter the definition of the relationship.

Properties Definition
Attribute Number of column in the primary key
First minimum and maximum The cardinality of the local table
Last minimum and maximum The cardinality count of the remote table

Advertising

4 - Scripting

See OWB - OMB - Data Rules, to see how you can with OMB create a Data Referential Rule

5 - Tutorial