The "Compare Schema" rule involves a comprehensive examination of data from two distinct schemas to verify that they are consistent with each other.
Consider there is a scenario in which consistency of two schemas is to be checked. The Compare Schema Rule will compare the schema structure between two sources, highlight differences in tables and columns, include disparities in data types where applicable.
In essence, the Compare Schema rule ensures that data across different sources aligns accurately, providing insights into potential discrepancies or variations.
For further information about the rule detail page including scope, threshold, notifications, etc., please see the detailed article Rule Detail page.
Detailed Steps:
Step 1: Log in to DvSum, proceed to the Data Dictionary tab, and select the relevant Data source and Table Name.
Step 2: Select the table name then select the Data Quality tab and choose Available Rules.
Step 3: Select the "⊕ Add Rule" button, then choose the "Cross-System DQ" category. From the list of options, click on "COMPARE Schema"
Step 4: Basic Input
In the Rule Wizard's Basic Input section, you need to fill in the Rule Description, source schema and target Schema corresponding to the tables in which you want to perform the comparison.
Step 5: Validate
After saving the rule, you'll see its definition. Click "Run" to execute and test the rule.
0 Comments