Differences between a data warehouse and data mart
Write a brief note on the differences between a data warehouse and data mart?
Expert
A data warehouse is for the enterprise and contains numerous subjects. A data mart is for a specific functional region and focuses on one subject. A data warehouse is data-oriented and flexible and contains detailed historical data. A data mart is project-oriented and restrictive and contains some historical data.
Illustrates the term bucket size, while the overlapping and collision arise at same time? Answer: Bucket size is one. When there is only one entry possible in the bu
Elucidate what are the basic requirements to join two sources in the source qualifier?
partial specialization and total specialization rules in enhanced erd.......
What do you understand by the term locking in DBMS?
Describe briefly the difference between a shared lock and an exclusive lock?
What is Redundant Array of Inexpensive Disks and what are various types of RAID configurations?
Explain what are new in the BO 5.1?
Explain the master/detail reports?
Give a brief introduction of the term real time data-warehousing?
What is a derived (artificial) primary key? When must this be used?
18,76,764
1925822 Asked
3,689
Active Tutors
1432926
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!