TARGIT Quality Check is a custom component for SQL Server Integration Services. The component assists in generating scripts for ensuring column and referential integrity in a relational SQL Server data warehouse database.
Main tasks solved
- Values: Maintenance of central lists of data values for updating missing data values
- Empty: Insertion of dummy data rows in empty tables
- Tables: Set up columns to be updated as well as foreign/primary key relations between tables
Why?
Values
Centralized maintenance of replace values means that changing current values will permeate the entire quality check script.
Empty
Originally designed for early version of SQL Server Analysis Services which did not work if tables are empty. Selecting one or more tables in the list will insert a dummy row in the table if the table is empty.
Tables
Related articles