Global Temporary tables
Write down a short note on the Global Temporary tables (GTT).
Expert
Global Temporary tables (GTT):
a) Whenever they are created, its definition goes to Data Dictionary.
b) If materialized data goes in temp space.
c) That’s why, data is active up to the session ends and definition will remain there up to its not dropped by using Drop table statement.
d) When dropped from some other session then its must is Drop table all; you can collect stats on the GTT.
Explain what do you mean by the virtual warehouse?
Explain in brief the term data warehouse.
Another company used statistic in reports is the total number of orders placed by a shopper. Complete the following steps to create a function named NUM_PURCH_SF that accepts a shopper id and returns the total number of orders the shopper has placed. Use the function in a SELECT statement to display
Write a brief note on the differences between a data warehouse and data mart?
Explain what needs to happen to convert a relation to third normal form?
Can you explain how to install an SSIS package?
Explain about the DBMS.
Give a brief note on the term degenerate dimension table?
Explain the slowly changing dimensions?
Explain the term Database Server?
18,76,764
1931018 Asked
3,689
Active Tutors
1437443
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!