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 Answer Oracle ETL Interview Question](https://globalguideline.com/public/images/interview/6.png)
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.
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