Retrieving audit history

The InfoSphere® MDM audit database is a duplicate of the operational database that does not include code and rule tables, but includes additional audit attributes.

The audit tables are populated at the time of execution of any transaction, using the default set of triggers for the product. These tables store the actual data that has been added or updated in the transaction.

InfoSphere MDM allows any inquiry (get) transaction to return either current or point-in-time data. If a valid <inquireAsOf> element occurs in the request control, the get transaction takes its data from the audit tables rather than the operational ones.