Overview
A metadata script in Validatar is a set of instructions written to extract specific metadata from a data source. The script correctly maps each field to its corresponding Validatar metadata column, ensuring that the metadata is accurately represented within Validatar.
Selecting a Data Source
Users can select a data source, separate from the test data set, from which to extract metadata. This flexibility allows users to pull metadata from the most appropriate or convenient source.
Writing a Metadata Script
To write a metadata script:
- Write SQL that extracts specific metadata from your chosen data source.
- Within the SQL, map each field correctly to its corresponding Validatar metadata column.
- Follow the on-screen help to ensure that all required metadata columns are included.
To make the process easier, a sample template script is provided:
- Copy the template script.
- Replace 'replace' with the table and/or column names from your chosen data source.
Conclusion
The feature to generate child tests using a metadata script in Validatar offers flexibility in choosing a data source for metadata extraction. The process requires writing a script that extracts and maps each field correctly to Validatar's metadata columns. A sample template script is also provided to get you started. This feature ensures that users can accurately represent the metadata within Validatar, enhancing their data testing capabilities.