There are various ways of Extracting Data from Source Systems.For example , You can use a DATA step, an Import Process .It depends with your input data styles. What kind of File/database it is residing in. Storing ur data in an ODS can be done thru an ODS stmt/export stmt/FILE stmt, again which depends on the file & data format ,You want your output to be in.
What is a database trigger? Name some usages of database trigger?
How many types of database triggers can be specified on a table? What are they?
Is it possible to use Transaction control Statements such a ROLLBACK or COMMIT in Database Trigger? Why?
What are two virtual tables available during database trigger execution?
What happens if a procedure that updates a column of table X is called in a database trigger of the same table?
Write the order of precedence for validation of a column in a table? I. done using Database triggers. ii. done using Integarity Constraints
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?
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
