The performance details provide counters that help you understand the session and mapping efficiency. Each source qualifier and target definition appears in the performance details, along with counters that display performance information about each transformation. You can view session performance details in the Workflow Monitor or in the performance details file.
By evaluating the final performance details, you can determine where session performance slows down. The Workflow Monitor also provides session-specific details that can help tune the following memory settings:
Buffer block size
Index and data cache size for Aggregator, Rank, Lookup, and Joiner transformations