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.
What is an Exception? What are types of Exception?
What is Pragma EXECPTION_INIT? Explain the usage?
What is Raise_application_error?
What are the return values of functions SQLCODE and SQLERRM?
Where the Pre_defined_exceptions are stored?
What is an oracle stored procedure?
What is a cursor for loop?
What are the cursor attributes used in PL/SQL?
What are the PL/SQL Statements used in cursor processing?
Explain the two type of Cursors?
rendc.org
Whether it is technological solutions or user-oriented innovations, We have put together for you the best sources of HR Interview Questions and Answers, Tech Ideas, and Programming Tutorials."
Get all the latest information on rendc.org
© 2022 | All rights reserved.
RENDC
welcome to www.rendc.org
