Oracle Extract transform load (ETL) Question: Download Oracle ETL PDF

Can we override a native sql query within Informatica? Where do we do it? How do we do it?

Answer:

Yes,we can override a native sql query in source qualifier and lookup transformation.

In lookup transformation we can find "Sql override" in lookup properties.by using this option we can do this.

Download Oracle ETL PDF Read All 39 Oracle ETL Questions

Previous Question	Next Question
Can we use procedural logic inside Infromatica? If yes how, if now how can we use external procedural logic in informatica?	What are parameter files? Where do we use them?