datahacks

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:

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

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

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

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

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:

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.