States the term Volatile temporary tables
States the term Volatile temporary tables.
Expert
Volatile Temporary tables (VTT) -
1. Table Definition is stored within System cache2. Data is stored within spool space.3. Because of that data and table definition both are active only up to session ends.4. No collects stats for VTT.
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Define the term DataStage?
Describe the difference between complexType elements and simple elements?
Explain the Aggregator Transformation?
Describe the difference between a regular sub query and a correlated sub query?
State the different steps of data warehouse design process.
Briefly explain the capabilities and concepts of Business Object?
What is the simplest sorting method to utilize in data structures?
Explain what do you mean by the virtual warehouse?
Describe briefly Recovering sessions?
18,76,764
1942676 Asked
3,689
Active Tutors
1446976
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!