SQL Editor
When attempting to edit the SQL Override in the Source Qualifier (or Lookup) the window for the SQL editor is cropped and does not display the entire window.
Cause
This behavior is seen when using the Designer client tool on a machine running in dual display mode with the Extend the desktop to this monitor option enabled.
Solution
To resolve this do the following:
Close Designer and run regedit .
Go to the following key:
HKEY_CURRENT_USER\Software\Informatica\PowerMa rt Client Tools\
Where PowerCenter_Client_Version is the PowerCenter client version (8.1, 8.1.1, 8.5, 8.5.1, 8.6, etc).
Change the values of the following to "0":
Expression Editor Position
Expression Editor Splitter Position
SQL Editor Position
SQL Editor Splitter Position
More Information
To avoid editor display problems when using dual display mode, do the following:
Open the Designer and move it to the larger monitor.
Open the Expression transformation.
Do not drag the Edit Transformations window to another position, leave it in the default position.
Open and work in the Expression editor.
If the Edit Transformations window is moved to another position, then the expression editor display will not display properly.
Notes:
This problem is not resolved when the machine is set back to single display mode.
The only sure way to avoid this issue is to use one monitor, the client tools are guaranteed to work properly with this configuration.
