ODS - Operational Data Store.
ODS Comes between staging area & Data Warehouse. The data is ODS will be at the low level of granularity.
Once data was poopulated in ODS aggregated data will be loaded into into EDW through ODS.
What are the Restrictions on Cursor Variables?
Can we declare a column having number data type and its scale is larger than pricesion ex column_name NUMBER(10,100), column_name NUMBAER(10,-84)
What will happen after commit statement?
Explain the usage of WHERE CURRENT OF clause in cursors?
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
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
