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.
What do you mean by the term stored procedure in the Teradata?
Explain how in a relation a supertype or subtype is mapped?
Illustrates the applications of ASA?
Briefly describe the term ‘BOMain.Key’?
List out the various detected patterns.
State the types of users in the Business Objects?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
Describe the difference between a regular sub query and a correlated sub query?
How to start/stop adaptive server enterprise while CPU reboots?
Explain the way of establishing connection by ODBC.
18,76,764
1943817 Asked
3,689
Active Tutors
1418290
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!