Informatica and Multiple Screens/Dual Monitors Issue

Working on Informatica PowerCenter on multiple screens can make you  lose your SQL or Expression Editors and also your mind.

Nowadays, working on multiple screen system is norm among developers. And if you are Informatica Developer you may face this issue, where all expression from expression editor is lost. This issue arises when dual display mode is running and you have dragged editor from main screen to secondary screen.

If your editor looks like below, means you are affected by this issue:

blog_2

How to resolve:

One way to resolve it, uninstall and reinstall Informatica PowerCenter 😛

But more subtle way is to follow below steps:

  1. Go to regedit

blog_3

2. In registry editor window, navigate to below path:

HKEY_CURRENT_USER -> Software -> Informatica -> PowerMart Client Tools -> 8.6.1 -> Designer -> Options -> Global -> Editor -> SQL

blog_4

3. Double click on “Expression Editor Position“. It will look like this :

blog_5

Here, change value for all rows to 0 (zero), and then click on OK.

blog_6

Repeat same steps for below Positions also:

  • Expression Editor Splitter Position
  • SQL Editor Position
  • SQL Editor Splitter Position

Once value for all the above positions are changed to 0.

Reopen your Informatica, then open Expression Editor and Voila !! You can see your lost sql/expression:

blog_7_last

Please note: This is not a permanent solution. This issue may again get resurface. Hopefully with latest versions of Informatica will be able to fix this bug permanently.

Advertisement

4 responses to “Informatica and Multiple Screens/Dual Monitors Issue

  1. landy April 30, 2015 at 4:45 pm

    Thank you so much. It works as you instructed.

  2. elena January 26, 2016 at 7:08 pm

    This doesn’t work if you don’t have LARs as in my case.

  3. elena January 26, 2016 at 7:08 pm

    This doesn’t work if you don’t have LARs as in my case. Informatica needs to come up with a HF to update the registries.

  4. sulbha September 5, 2017 at 5:57 pm

    I am using three screens and above solution didn’t work for me but what I did is deleted the below from SQL folder itself
    Expression Editor Position
    Expression Editor Splitter Position
    SQL Editor Position and
    SQL Editor Splitter Position
    Remove your laptop from dock, go to Registry Editor window, navigate to below path:

    HKEY_CURRENT_USER -> Software -> Informatica -> PowerMart Client Tools -> 9.6.1 -> Designer -> Options -> Global -> Editor -> SQL right click on Expression Editor Position and press Delete do the same for all other three options, connect to dock and then make the other monitor as main screen and open Informatica Designer and you see the issue is gone, you can view your SQL in SQL Editor.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: