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

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

Oracle ETL Interview Question
Oracle ETL Interview Question

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 Interview Questions And Answers PDF

Previous QuestionNext 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?