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 the Hash file and the Sequential File?
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Define the term data aggregation?
Give definition of data structure?
Describe briefly Recovering sessions?
Explain about the Active and Passive Stage?
Is it possible that two tasks be assigned to the similar Partition in Sybase?
Briefly describe time series algorithm in data mining?
Describe how a scenario is employed for business rule?
Explain the various types of stages?
18,76,764
1941535 Asked
3,689
Active Tutors
1424992
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!