I have a mapping with one port in SQ transformation with char data type. Now I want the SQ to use query(obviously will return one column) that I will place in a unix path. Whenever I change the query in unix, mapping will generate different data set depending upon the query. Is there any way out to do that with SQ or even with others transformation? I don't want to parameterise the query and to use the parameter in SQ. This will possibly lead to size constraint of the query.
I still don't understand the aversion to parameter file - how big can a query that returns 1 column be? If you're in doubt then see the following very similar thread where nico has provided good indication on the string parameter limits i.e. over 32000 characters. https://network.informatica.com/thread/20140
You could also expand your allocation by using SELECT $$Selection FROM $$Sources WHERE $$Conditions