Improve log fast data masking information

Idea created by Nieves on Jul 28, 2017
    New
    Score6
    • diaan05
    • Nieves
    • Francois.Calvert
    • Gary.P.Johnson
    • gilta03
    • Anil Kumar Appukuttan

    Hello,

    We are using fast data masking with schemas that contain many tables and fields to update and it is noted that the log it generates does not contain all the necessary information.
    We would need the following information if possible:

    We need the LOG to display the following information for each table:
    • Name of the table being treated.
    • Name of the column being processed.
    • Total of treated queues.
    • Total of rows processed successfully.
    • Total unprocessed rows.
    • Total of unprocessed rows by NULL.
    • Time Start, end and duration of the table execution.

    In addition, at the end of each process should show a total of totals:
    • Total processed tables.
    • Total of all columns processed.
    • Total of all rows processed successfully.
    • Total of all unprocessed rows
    • Total of all rows not processed by NULL value
    • Start time, end and duration of the entire process.


    For example:


    > Thread: TABLA_ALERTAS- COLUMNA_ID:
    - Total Treated: 3000
    - Total Successfully Processed: 1340
    - Total unprocessed rows: 1660
    - Total unprocessed rows NULL value: 60
    - Duration: 2017.06.28 10: 18: 26.467 -2017.06.28 10: 28: 46.467 (00: 10: 20.00)
    > Thread: TABLE_ALERTAS- COLUMN_DATA:
    - Total Treated: 1000
    - Total Successfully Processed: 1000
    - Total unprocessed rows: 0
    - Total unprocessed rows by NULL value: 0
    - Duration: 2017.06.28 10: 28: 46.467 -2017.06.28 10: 28: 48.467 (00: 00: 00.20)
    > Thread: TABLA_ALERTAS- COLUMNA_FECHA:
    - Total Treated: 500
    - Total Processed successfully: 0
    - Total unprocessed rows: 500
    - Total rows not processed by NULL value: 500
    - Duration: 2017.06.28 10: 28: 48.467 -2017.06.28 11: 28: 48.467 (01: 00: 00.00)

    Tables: 1
    Columns: 3
    Rows Treated: 4500
    Rows processed successfully: 2340
    Rows not processed: 2160
    Rows not processed by NULL: 560
    Duration: 2017.06.28 10:18:26,467 - 2017.06.28 11:28:46,467 (01: 10: 20.20)