Database Reference
In-Depth Information
The tracing level
The tracing level defines how much detailed information you wish to write to the session
log. When you run the process, Integration Service writes the information about the run in
the session log. Setting a proper tracing level will help in improving the performance.
Using variable ports
If you are performing the same operation multiple times in a transformation, consider cal-
culating the value in a variable port and use the variable port value multiple times in the
transformation. Suppose you need to convert the first name and last name in uppercase,
concatenate them, and also cut part of data. Instead of using the
UPPER
function every
time, use the variable port to convert the data in uppercase and variable port to perform
other operations. This way, you save the time of performing the save operation multiple
times.
Optimizing Filter transformations
You can use Filter transformations as early as possible in the mapping to avoid processing
unnecessary data. If you filter unwanted records early in the mapping, you can enhance
performance.
Similarly, using the Router transformation instead of multiple Filter transformations will
help save time.
Optimizing the Aggregator transformation
Always pass sorted data to the Aggregator transformation to enhance performance. When
you pass sorted data, Integration Service needs to save less data in the cache, which helps
in the enhancement of the performance.
You can also improve the performance of the Aggregator transformation by executing
groups of numeric columns. For example, consider grouping the data in the department ID
instead of the location. This is only possible as per your business requirement.
Use incremental aggregation whenever possible in the session properties to enhance the
performance. When you use incremental aggregation, the performance is improved as the
Aggregator transformation now needs to calculate fewer records.
