Informatica Variables are crazy

I really have to say the idea of the Informatica mapping variables are crazy. In case of using the mapping variables as normal variables to pass information to the next sessions, use non-persistent workflow variables to override them in the “pre-session variable assignment”.

http://datawarehouse.ittoolbox.com/groups/technical-functional/informatica-l/problems-with-setvariable-3283342

The is Sukumar’s comment

Workflow Variable:

The Integration Service looks for the start value of a variable in the following order:

1. Value in parameter file
2. Value saved in the repository (if the variable is persistent)
3. User-specified default value
4. Datatype default value

Mapping Variable :

The Integration Service saves the latest value of a mapping variable to the repository at the end of each successful session. During the next session run, it evaluates all references to the mapping variable to the saved value. You can override a saved value with the parameter file. You can also clear all saved values for the session in the Workflow Manager.

The Integration Service looks for the start value in the following order:

1. Value in parameter file
2. Value in pre-session variable assignment
3. Value saved in the repository
4. Initial value
5. Datatype default value

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.