At the heart of Oracle9i Lite is Oracle9i Lite database, a powerful lightweight relational database that offers complete transactional support, data integrity constraints, and the ability to construct queries on the fly.
The data volumes in data warehouse databases make traditional referential integrity constraints too costly.
Consistency means that the transaction represents a correct transformation of the application state — that any integrity constraints implicit in the application are not violated by the transaction.
Also, the Q Apply program does not drop referential integrity constraints on nicknames during the loading process and then restore them.
