Search code examples
sqlteradatainformaticainformatica-powercenter

Pass a query to informatica

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!!

Solution

  • You can put the query in a view and reference it in the parameter.