Aggregate tables and lookup tables
Briefly describe the employ of aggregate tables and lookup tables?
Expert
Updating the data warehouse, a lookup table is employed. When placed on the fact table or warehouse depended on the primary key of the target, the update is happens only by permitting new records or updated records depending on the condition of lookup.
The appeared views are aggregate tables. It holds summarized data. For instance, to make sales reports on monthly or weekly or yearly basis in place of daily basis of an application, the date values are aggregated in week values, week values are aggregated in month values and month values in year values. To play this procedure @aggregate purpose is employed.
Is the shortest distance between any 2 specified nodes is given by minimum spanning tree?
Explain how do you produce the Sequence number within the Data stage?
In Sybase does table Partitioning needs user-defined segments?
Illustrates the difference between a user’s defined function and a stored procedure?
Explain what is meant by the term stored procedures?
Specify the types of connections we use while connecting with the database?
Specify the different application areas of the data mining.
I have to prepare an assignment on the topic "SQL Triggers and Procedures". Please help me to complete my assignment.
Explain the term Account and Directory options?
Explain what do you mean by the spatial data mining?
18,76,764
1958360 Asked
3,689
Active Tutors
1430186
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!