How to run a sql query in Informatica other than source qualifier and lookup?

I have use a query to return one data for one column, but it taking very long time. Can i run this query in middle of pipeline using any other transformation?

Thanks In Advance.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum