MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

12 Tips to optimize session performance of Informatica Server

Published on 13 May 15
1608
0
1
12 Tips to optimize session performance of Informatica Server - Image 1

  1. Generally people tend to store flat files in a machine that is different from the server. Relocate the flat files into the machine that contains informatica server.
  2. Moving target database into server system may improve session performance because it minimizes the connections to sources, targets and informatica server.
  3. Distributing the session load to multiple informatica servers may improve session performance.
  4. Prefer ASCII over Unicode for data movement while running informatica server, because ASCII data movement mode stores a character value in one byte. Unicode mode takes 2 bytes to store a character.
  5. Optimize the query if a session joins multiple source table in one source qualifier.
  6. Avoid transformation errors to improve the session performance.
  7. Enable look up cache if your session contains lookup transformation.
  8. Drop constraints and indexes before running the session and re-build them after session completion. Because constrains and indexes in target can slow down the loading.
  9. Partitioning of session helps creates multiple connections to sources and targets and loads data in parallel pipe lines.
  10. Create filter transformation nearer to the sources or use the filter condition in source qualifier, if your session contains filter transformation.
  11. Use incremental aggregation if your session contains an aggregation transformation.
  12. Lastly, shared network connections effect the session perfomance, avoid network connections by moving the data into a local disk.

12 Tips to optimize session performance of Informatica Server - Image 1

  1. Generally people tend to store flat files in a machine that is different from the server. Relocate the flat files into the machine that contains informatica server.
  2. Moving target database into server system may improve session performance because it minimizes the connections to sources, targets and informatica server.
  3. Distributing the session load to multiple informatica servers may improve session performance.
  4. Prefer ASCII over Unicode for data movement while running informatica server, because ASCII data movement mode stores a character value in one byte. Unicode mode takes 2 bytes to store a character.
  5. Optimize the query if a session joins multiple source table in one source qualifier.
  6. Avoid transformation errors to improve the session performance.
  7. Enable look up cache if your session contains lookup transformation.
  8. Drop constraints and indexes before running the session and re-build them after session completion. Because constrains and indexes in target can slow down the loading.
  9. Partitioning of session helps creates multiple connections to sources and targets and loads data in parallel pipe lines.
  10. Create filter transformation nearer to the sources or use the filter condition in source qualifier, if your session contains filter transformation.
  11. Use incremental aggregation if your session contains an aggregation transformation.
  12. Lastly, shared network connections effect the session perfomance, avoid network connections by moving the data into a local disk.


This blog is listed under Data & Information Management Community

Related Posts:
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top