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.
Define the efficient data structure used within the internal storage representation in RDBMS?
Explain the terms SQL Server and adaptive server enterprise?
Name the methods that are available in storing sequential files?
What are the disadvantages in File Processing System?
Describe briefly the different methods of loading Dimension tables?
Specify different types of transformations available in the Informatica?
Briefly describe the term a Cube and Linked Cube with reference to data warehouse?
Explain, why we use the lookup transformations?
Explain about the Buffer Manager in relational database management system.
What are the two means to explain the content of XML documents?
18,76,764
1957642 Asked
3,689
Active Tutors
1454018
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!