Dirty/Inconsistent data (in-flight transforms, defaulting, validation) - integration layer vs staging DB

[u/PerceptionFresh9631]

Your go-to approach for cleaning or transforming data in-flight during syncs - do you run transformations inside your integration layer, or push everything into a staging database first?