RE: what are the steps follow in performance tuning ?
Steps for performance tuning: 1) Target bottle neck 2) source bottle-neck 3)mapping bottle-neck etc..As a developer we just can clear the bottle necks at the mapping level and at the session level.
for example 1) Removing transformation errors. 2) Filtering the records at the earliest. 3) Using sorted data before an aggregator. 4) using less of those transformations which use cache. 5) using an external loader like sql loader etc to load the data faster. 6) less no of conversions like numeric to char and char to numeric etc 7) writing an override instead of using filter etc. 8)increasing the network packet size. 9) all the source systems in the server machine to make it run faster etc pal.
RE: what are the steps follow in performance tuning ?
Hai Friends,Performance tuning means techniques for improving the performance.1. Identify the Bottlenecks(issues that reduces performance)2. Configure the Bottlenecks.The Hierarchy we have to follow in performance tuning is a) Target b) Source c) Mapping d) Session e) SystemIf anything wrong in this plz. tell me. because I am still in the learning stage.
