opbang

 Profile Answers by opbang 

• Sep 26th, 2006

 

Bottleneck in Informatica

 

Bottleneck in ETL Processing  is the point,  by which the performance of the ETL Process is slowr.    

When ETL Process is in progress, first thing login to workflow monitor and observe performance statistic. I.e. observe processing rows per second.  In SSIS and Datastage, when you run the job, you can see at every level how many rows per second is processed by the server.

 

Mostly bottleneck occurs at source qualifier ? during fetching data from source, joiner, aggregator, Lookup ? Cache Building Session.

 

Removing bottleneck is performance tuning.