Skip navigation
Contact Us
2603 Views 12 Replies Latest reply: Dec 3, 2012 12:43 AM by will i RSS
venkat yatham Novice 21 posts since
Feb 4, 2012
Currently Being Moderated

Nov 27, 2012 6:01 AM

Informatica Job Performance Issue

Hi

 

We have one informatica job which is taking 6 to 7 hrs to process total of 80000 records. We noticed that It took just 12 mins to process first 20000 records and then its slowing going down with throughput

 

Severity Timestamp Node Thread Message Code Message

INFO 27/11/2012 6:48:21 PM node1_******** READER_1_1_1 RR_4049 RR_4049 SQL Query issued to database: (Wed Nov 28 00:18:21 2012)

-----------------------

-------------------------

INFO 27/11/2012 6:48:31 PM node1_******** READER_1_1_1 RR_4050 RR_4050 First row returned from database to reader: (Wed Nov 28 00:18:31 2012)

 

Query response time is very quick in 30 seconds source query returning the output. The session starts with read throughput of 89/sec and slowly getting down the throughput to a single digit number.

 

We tried the following options :

-created indexes on source system and executed the jobs. Still the behavior is same.

 

Please provide any other suggestion or setting to be done in session properties to resolve the following issue. I can provide any other info required.

 

Thanks,

Venkat

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points