Source order counts must agree with the transformed aggregate.
Show operators missing, duplicate, and excluded-row reasons.
Which quality approach is most appropriate?
Compare counts, sums, and checksums in a manifest and stop publication when an unexplained difference appears.
Detailed explanation
The manifest makes differences measurable and their causes traceable.
The manifest makes differences measurable and their causes traceable.
Valid filters and delayed data are not separated, and recovery input may be lost.
Valid filters and delayed data are not separated, and recovery input may be lost.
API activity is not a count of business records.
API activity is not a count of business records.
A standalone output count cannot reveal missing input or unexplained exclusions.
A standalone output count cannot reveal missing input or unexplained exclusions.
Check official documentation
Compare the following points with the official documentation.
AWS Glue job bookmarks、manifest、data reconciliation、ETL validationの公式説明を確認する。
What to confirm
出力件数だけの監視と入出力照合の違いを説明できる。
Key points
- Reconciliation
- Manifest
- Count check
- Checksum
Notes
- Environment: AWS公式DEA-C01試験ガイドと各サービスの公式ドキュメントの確認
- Confirm current AWS service behavior in the official DEA-C01 documentation.
Foundation review
Difference classification
Separate legitimate filters, deduplication, late arrivals, and missing data.
Auditability
Keep the processing window, input version, code version, and output version together.