reconcile_staging
Verify that transform maps correctly moved staging records to target table by comparing field values and identifying discrepancies.
Instructions
Compare the ServiceNow STAGING table against the TARGET table to verify that the transform map correctly moved all records from staging into the real table.
This is the staging → target leg of the three-layer quality check: Source → [staging] → Target
Fetches the most recent N staging records, looks up their corresponding target records via sys_target_sys_id, then compares every mapped field value.
Returns: per-record diffs, per-field accuracy, missing target records.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| staging_table | Yes | ServiceNow import set staging table (e.g. u_jira_import) | |
| target_table | Yes | ServiceNow target table (e.g. incident) | |
| field_mappings | Yes | { stagingField: targetField } | |
| sample_size | No | How many staging records to check | |
| transform_rules | No | ||
| date_fields | No |