Informatica allows SQL to be executed in the source database and the results can be pulled by the PowerCenter.