Effective in version 10.0, you can parameterize the connection for an SQL transformation. Define the parameter in the mapping. Then, assign the parameter to the Connection Name in the SQL transformation run-time properties.

For more information, see the

SQL Transformation

chapter in the

Informatica 10.0 Transformation Guide

.