Data aggregation
Define the term data aggregation?
Expert
An operational data source generally consists of the records of individual transactions just like the product sales. If user of the data warehouse only requires a summed total, you may decrease the records to more manageable number by aggregating the data.
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Define the explaining plan and how is this used?
Explain the following terms: Proactive, Retroactive and immediate Update.
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Describe briefly three types of binary relationships in DBMS?
Write about the independent and dependent data marts.
What is the archtetype or instance pattern?
Explain about the Active and Passive Stage?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
Describe the difference between differential backups and SQL Server 2000 complete?
18,76,764
1946610 Asked
3,689
Active Tutors
1416047
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!