Informatica SQL Query Expression not showing in Source Qualifier

https://network.informatica.com/thread/39849

[rakesh bobbala]
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\\Designer\Opt ions\Global\Editor\SQL
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

SQL Server Partition

SQL Server Partition is good for ETL process but not easy to utilize on querying.

Informatica automatic converting the date values

The Java Transformation stores the date time values in the Unix time. It is not time zone aware. But, the Informatica is time zone aware. The values of the date time output ports are automatically converted to local time zone. For example, the date value 05 Aug 2016 03:34:00 stored in Java object System.util.Date will be converted to 04 Aug 2016 10:34:00 Chicago time, given the server is in Chicago.

This is a related discussion.
https://network.informatica.com/thread/12513