You can create a read test mapping to identify source bottlenecks. A read test mapping isolates the read query by removing the transformation in the mapping.
To create a read test mapping, complete the following steps:
Make a copy of the original mapping.
In the copy of the mapping, keep only the source transformations and any custom joins or queries.
Remove all other transformations.
Connect the sources to a flat file target.
Run the read test mapping. If the mapping performance is similar to the original run, you have a source bottleneck.