Skip navigation
Contact Us
1897 Views 8 Replies Latest reply: Jan 21, 2013 2:15 AM by Zafar Habib RSS
Zafar Habib Novice 27 posts since
May 14, 2012
Currently Being Moderated

Dec 26, 2012 9:07 PM

Performance Issue in Informatica Mapping

Dear Experts.

 

I am facing problem in INFORMATICA

 

I have deployed informatica mapping in DEVELOPMENT server which is running fine and 5 million records processed in 2 or 3 minutes ,

however the same mapping transfer into PRODUCTION server which takes too much time and processed 3 million records in 45 minutes or more.

 

I really dont know why it is impact so much difference between DEVELOPMENT and PRODUCTION server.

  • Ankit Bhargava Newbie 2 posts since
    Feb 22, 2012
    Currently Being Moderated
    Dec 26, 2012 10:08 PM (in response to Zafar Habib)
    Performance Issue in Informatica Mapping

    Hi Zafar,

     

    Problem might be because in live enviornment there are few parametres like :

     

    1. Target table might be accessed by more processes.

    2. CPU utilization might be more as too many processes running at he same tym.

     

    Check with your INFA Admin and also check the batch logs to get the proesses running at the same time.

     

    - Ankit

  • Surya Prakash Reddy Novice 31 posts since
    Aug 24, 2011
    Currently Being Moderated
    Dec 27, 2012 5:46 AM (in response to Zafar Habib)
    Performance Issue in Informatica Mapping

    Check database configeration.

    May be  executing more jobs at time in production server.

  • Feroz S Novice 33 posts since
    Nov 21, 2012
    Currently Being Moderated
    Dec 27, 2012 6:02 AM (in response to Zafar Habib)
    Performance Issue in Informatica Mapping

    Habib,

     

    1. Check your session config and see if its not running in "verbose" mode

    2. Check where you are writing your logs. whether on the local drive/NAS

    3. Check the Reader/Writer/Process threads and find out the Utilization %

    4. Analyze your map and findout where the cache happens for lookup,aggreg, so on..

    5. Check Integration service - Ascii mode is faster

    6. You have not mentioned about the source/target - Next steps will depend on their types

     

    Regards,

    Feroz

    • Ashish Goel Newbie 6 posts since
      Nov 20, 2012
      Currently Being Moderated
      Jan 3, 2013 12:41 PM (in response to Zafar Habib)
      Performance Issue in Informatica Mapping

      Hi Zafar, not sure if this issue is still open. Did you check the busy percentage for reader, writer and transformations. It will indicate the one thats taking most time. Also, the session log will provide information on when the sql was sent to the source database and when the first record was retrieved.

       

      Thanks,

      Ashish

More Like This

  • Retrieving data ...

Bookmarked By (0)