Skip to content
Advertisement

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

Advertisement

Answer

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

User contributions licensed under: CC BY-SA
5 People found this is helpful
Advertisement