I agree, do your data scrubbing and transformation as near upstream as possible. Transform it once in staging, or transform it 1,000x in the application layer. Many organization don't get how that's the most important aspect of a data warehouse: achieving conformity of enterprise data.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho