Applications developed using Nucleus technology can automatically update a data warehouse.

Transaction records
Each update created through a Nucleus application generates a real-time transaction record documenting any changes in the data as well as a time-stamp including date, time, user, port, account, file and the Item ID of each record modified.

Real-time transaction records can be processed to.

• Roll out the "before" updates from a data warehouse
• Roll-in the new data
• Update IBM Blade repositories
• Update Business Intelligence applications (BI)
• Update Oracle, DB2 or other databases
• Support "replication" facilities
• Update associated data sets on local or foreign systems

Rollback and Update
As transaction records provide both before and after conditions of changed fields, update and rollbacks can be easily implemented. On-line, real-time data-warehouse information is easily achieved with Nucleus technology.
More

Nucleus technology - Accelerating change