I am trying to pass a complete query to source qualifier of Informatica powercenter Designer. Since the query is large I cannot parameterize it (limitations of UNIX also comes here).
So, is there a way I can refer and run a query without hardcoding it inside Informatica, and get the result in Informatica.
Any help!!
Advertisement
Answer
You can put the query in a view and reference it in the parameter.