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.
Describe the meaning of each of the transaction stages supported by SQL Server?
Describe about generating a report tool by utilizing the report tool and the report wizard?
Define the term Data Independence?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
State the term Sybase 365.
What is meant by the Surrogate key?
Explain what is meant by the repository and what does it consists of?
Specify the major components of the Designer Interface?
Specify the various types of Aggregation?
Briefly describe the employed of data cube?
18,76,764
1935869 Asked
3,689
Active Tutors
1417073
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!