Developing the journal tables to track changes
The application tables are becoming a source of information for the data warehouse solution. Changes against these tables should be recorded so that a complete audit log can be constructed.
Getting ready
In order to track changes, a journal table is needed. This table is identical to the definition of the original table, but has a few additional columns to record information on actions, the date, and the user who made the change.
How to do it...
Journal tables are useful for auditing the changes that are made to information, and can be used to roll back information, should it be required.
The journal table we will use is a track change in the customer table, as shown in the following code snippet:
CREATE ...
Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
