pal

• Feb 9th, 2007

 

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.

ggk.krishna

 Profile Answers by ggk.krishna 

• Feb 13th, 2007

 

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.

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

 

Thananjayan

 Profile Answers by Thananjayan Questions by Thananjayan

• Nov 17th, 2007

 

Hi Friends,

Please clarify me,What is mean by "bottle neck".For ex
1) Target bottle neck
2) source bottle-neck
3)mapping bottle-neck

I am not aware what does this bottle neck meant.

Thanks for your help in advance.

Thanks,
Thana

J.David Sukeerthi Kumar

• Nov 26th, 2007

 

Bottle neck means drawbacks or problems

vivek1708

 Profile Answers by vivek1708 

• Jul 30th, 2008

 

Target commit intervals and Source - based commit intervals.