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.

Advertisements

3 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.

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: