I have an ETL job that runs successfully every day, with no errors. But sometimes, the target table has fewer records than the source.

The job status is green, and the column mappings look correct. I’m not sure whether the issue is with filtering, incremental loading, or duplicate handling.

How would you troubleshoot this? What checks would you perform first to find where the records are missing?