Transaction Logs

The Transaction Logs section provides comprehensive details about all transactions made to the tables. This feature is crucial for auditing, tracking changes, and ensuring data integrity.

1. Transaction Details

• Transaction ID: Unique identifier for each transaction.

• Table Name: Name of the table involved in the transaction.

• Database Name: Name of the database where the table resides.

• Source Name: The source of the transaction (e.g., application or user).

• Transaction Type: Type of transaction, which can be:

  • Insert

  • Update

  • Delete

  • SCD Update (Slowly Changing Dimension Update)

• Row Count: Number of rows affected by the transaction.

• Duration: Time taken to complete the transaction.

• Status: Outcome of the transaction, either:

  • Success

  • Failed

2. Search and Filter Capabilities

• Search by Transaction ID: Users can search for specific transactions using their unique Transaction ID.

• Filter by Table Name: Users can filter transactions by specifying the table name.

• Filter by Source Name: Users can filter transactions based on the source of the transaction.

• Filter by Transaction Type: Users can filter transactions by the type of transaction (Insert, Update, Delete, SCD Update, SCD Delete).

• Filter by Started By (Account Name): Users can filter transactions by the account name of the user who initiated the transaction

On click on the particular transaction, it directs to a detailed transaction details page.

3. General Details

4. Error Details