You can use Data Validator to store the information related to a job in the database. The stored information can be used as a metadata for the generation of reports. For this purpose, a new schema is provided to record the job information, such as Import Details, Validation, Implicit Delete, and Export Details. If you delete a job from the target system, only that job is deleted, its details are still stored in the database. This happens only if you select the Record Job Details option when creating a job definition, and associate it with that specific job. You can find the job summary details in the staging system.
The following image shows the new class definitions and the corresponding property definitions that are modeled to hold job details.
The following class definitions are delivered with the software.
-
SDVJobSummary - Stores the basic details of a job, such as Import Stage Details and Validation Stage Details.
-
SDVJobSummarySeverityItem - Displays the severity items of a job, such as warnings, errors, and the count.
-
SDVJobSummaryTarget - Stores export stage details and implicit delete stage details of each target system.
-
SDVJobSummaryImportFile - Stores import file that is used to execute a Job.
Each class definition contains property definitions that allows you to define the properties of a job, such as name, description, and other properties. The SDVJobSummarySeverityItem, SDVJobSummaryTarget, and SDVJobSummaryImportFile class definitions are associated with the main class definition SDVJobSummary.
-
The job details are stored in the staging system even after deletion of the job from Data Validator.
-
To view job details, you must be working in a role associated with the VTLAdmin access group.
For example, create a job definition, named Test by applying Record Job Details option. For more information, refer to Create a job definition. Use this job definition to create a new job named Job1.
The following job details are stored in the staging system. If you delete the job Job1, its job details will still be available in the staging system.
Select the Record Job Details option to store the job information such as Import details, Validation, Export details
and other job information.