First, we need to identify where the performance problem come from. The bottleneck can be:
- Source Extract
- Transformation
- Lookup
- Target Write
I will talk about how to isolate the problems and go over each about how to investigate the problem in each of these area.
