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

Tell me 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 Extract, transform, load (ETL) Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What are snapshots? What are materialized views & where do we use them? What is a materialized view log?Explain What are the various methods of getting incremental records or delta records from the source systems?