What is data mart
Illustrate the term data mart. What do you mean by it?
Expert
Data mart refers to the database which consists of the subset of data present in the data warehouse. Data marts are generated to structure the data within the data warehouse as to issues like hardware platforms and access control strategies. We may divide the data warehouse into data marts after data warehouse has been generated. Data marts are typically implemented on the low-cost departmental servers which are UNIX (or) windows/NT based.
What is meant by the term merge?
Give a brief differentiation between metadata and data dictionary?
State the difference between OLTP and OLAP?
What is meant by the User Objects? Specify some of its restrictions?
Illustrates the applications of ASA?
Write down a short note on the difference between two and three-tier architectures?
Give brief introduction of the term an OLAP system and OLTP system?
Provide a brief introduction of the term ‘Data Mart’?
Specify the enhancements which are made within datastage 7.5 and also compare with the 7.0?
Describe in brief about the Sybase group?
18,76,764
1958591 Asked
3,689
Active Tutors
1460498
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!