Volatile Temporary tables
Write down a short note on the Volatile Temporary tables (VTT).
Expert
Volatile Temporary tables (VTT):
a) Table Definition is stored in the System cache.
b) Data is stored in the spool space.
c) That is why, data and table definition both are active merely to session ends.
d) No collect stats for VTT.
Explain the object qualification?
Explain how one source columns or the rows may be loaded within the two different tables?
Which efficient data structure is used in RDBMS, for internal storage representation?
What is meant by the term merge?
Describe briefly reusable transformations?
Clarify how we can export mappings to production environment?
Describe briefly the different methods of loading Dimension tables?
Describe briefly Aggregate transformation?
What is meant by the term query subject?
Briefly describe the employ of aggregate tables and lookup tables?
18,76,764
1926203 Asked
3,689
Active Tutors
1413429
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!