We have many tables that have a different retention policy between source and destination. Since redshift is a data warehouse and it's a scale out solution we want to store more data compared to the source (SQL Server). That's one of the reason why we pick Redshift to begin with. Unfortunately as of now we have to suck in all the deletes and basically ignore them in a different process.
Would be nice to have the ability to throw away the deletes.