Tag Archives: expression editor

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