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.
State the difference between OLTP and OLAP?
Name the methods that are available in storing sequential files?
Illustrate the main merits of employing stored procedures?
Specify the types of dimensions?
Explain the relationship between JDBC and Sybase.
Explain the four kinds of indexes?
Illustrates the term data structure node class?
Write down a short note on XML and also describe the uses of it?
Specify the 2 modes of data movement in the Informatica Server?
Under what conditions should indexes are employed?
18,76,764
Questions Asked
21,311
Experts
9,67,568
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!