August 2017
Beginner to intermediate
426 pages
9h 36m
English
This is another simple method to find the source bottleneck if you are extracting the data from the table. When you use the source qualifier to read the data from the database table, the integration service writes a query to extract the data. Copy the query and run the same query at the database level in SQL developer or a similar tool. Compare the time taken by the query to execute at both places, which can give you an idea if the source has a bottleneck.
Read now
Unlock full access