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 occurs while rows are determined using a FETCH statement?
Write about the Sequencers?
Write down a short note on the difference between an ERD and EER.
Explain the types of the Containers?
Describe the differences between an extranet and an intranet.
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?
State the different steps of data warehouse design process.
Where is the GRANT table option usually done after creating tables dynamically within the Teardata? While tables are newly created, what are the default role and default privileges that get assigned?
Define the term OCI?
What are the disadvantages in File Processing System?
18,76,764
1937113 Asked
3,689
Active Tutors
1458984
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!