Reducing the number of transformations

Using conditional filters

Droping Indexes & Key Constraints before loading

Using Multi - pass reads from source