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 difference types of the stages?
What is meant by the Data warehouse?
Illustrates storing of data in stored procedures increase the access time?
Write down the differentiation between view and materialized view?
Describe the relationship of OLE DB, ADO, and ODBC?
List out the main attributes of the data stage?
Distinguish between the query answering and direct query answering.
What is significance of “ * ” ?
Explain the term Repository Tables within the Data Stage?
Explain, why we use the lookup transformations?
18,76,764
1955502 Asked
3,689
Active Tutors
1450140
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!