Recent Posts
Recent Comments
sulbha on Informatica and Multiple Scree… | |
elena on Informatica and Multiple Scree… | |
elena on Informatica and Multiple Scree… | |
landy on Informatica and Multiple Scree… |
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:
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:
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.
Thank you so much. It works as you instructed.
This doesn’t work if you don’t have LARs as in my case.
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.
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.