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.
Describe briefly the term SQL Server Analysis Services cubes?
Give a brief differentiation between metadata and data dictionary?
What is meant by the parameter file?
What is BCA? Discuss its features?
Explain the function of metadata for the three-layer architecture?
Which of the following method does not support sorting (Exchange, Selection, Insertion, Deletion)?
Write down the steps for transforming an entity into a table?
Explain the following term: a) ROLAP b) MOLAP
Give a brief introduction of the term ‘SQL Server 2005 Analysis Services’ (or SSAS)?
Describe briefly the measure objects?
18,76,764
1958754 Asked
3,689
Active Tutors
1416026
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!