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 what is meant by the WebI or Web Intelligence?
Explain the term Enterprise and Workgroup modes?
Illustrates the way to assign an address to an element of a pointer array? Answer: We can assign a memory address to an element of an array of pointers by usin
Explain, why we use the lookup transformations?
Why there is a need to create the user object?
Explain the term power center repository?
Write down the level of Granularity of a fact table?
Explain the Normalizer transformation?
Specify the use of data stage designer?
Describe briefly the term SQL Server Analysis Services cubes?
18,76,764
1950093 Asked
3,689
Active Tutors
1422803
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!