Multiple choice technology

If there is a target bottleneck we can check it by

  1. Replacing the target with a flat file and running the session

  2. Removing transformations

  3. Both a and b

  4. Either a or b
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To isolate whether a target table is the performance bottleneck, replace it with a flat file target. If the session runs significantly faster, the bottleneck is confirmed at the target (database inserts, constraints, indexes). This is a standard troubleshooting technique in ETL performance tuning.

Keep practicing — related questions