Database Reference
In-Depth Information
As seen in the preceding statistics, the Writer thread is busy for 99 percent of the time as
compared to the Reader and Transformation threads. We can say that in this case, the tar-
get is the bottleneck. Similar to this, you can identify whether the Source or transforma-
tion have bottlenecks in other cases.
Configuring the sample target load
It is a simple thing to understand that loading the data into the target table will take more
time as compared to loading the data into the target file. Consider that you are loading the
data into the target table in your mapping, configuring a sample run, and trying to load the
same data into a test target file. Check the difference between the runtime of both the pro-
cesses. If there is a significant difference, you can easily say that the database target table
has the bottleneck.
