chore: introduce source category for deduplication

[achettyiitr]

Description

• We want this to filter and group dedup_rows based on source category as well. Especially extract sources because they use a different deduplication strategy based on recordID.

Linear Ticket

• https://linear.app/rudderstack/issue/PIPE-69/clean-up-duplicate-dashboard

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

Patch coverage: 100.00% and project coverage change: +0.01% 🎉

Comparison is base (5a36137) 68.09% compared to head (a49f346) 68.11%.
Report is 3 commits behind head on master.

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #3730      +/-   ##
==========================================
+ Coverage   68.09%   68.11%   +0.01%     
==========================================
  Files         333      333              
  Lines       51462    51460       -2     
==========================================
+ Hits        35042    35050       +8     
+ Misses      14134    14127       -7     
+ Partials     2286     2283       -3     

Files Changed	Coverage Δ
warehouse/integrations/deltalake/deltalake.go	74.28% <100.00%> (+0.05%)	⬆️
warehouse/integrations/postgres/load.go	90.63% <100.00%> (+0.01%)	⬆️
warehouse/integrations/redshift/redshift.go	66.81% <100.00%> (+0.02%)	⬆️
warehouse/integrations/snowflake/snowflake.go	64.93% <100.00%> (+0.06%)	⬆️

... and 10 files with indirect coverage changes

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.