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.
Explain the repository domains?
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?
What are the properties of Isoquants?
Specify the types of prompt in the Cognos?
Illustrates the term explain and how does this work?
Explain the Stored Procedure transformation?
Why use references quite than pointers within the public API, mainly for arguments that are modified?
Provide a brief introduction of the term ‘junk dimension’?
State the difference between OLTP and OLAP?
Explain the following term: a) ROLAP b) MOLAP
18,76,764
1938185 Asked
3,689
Active Tutors
1429177
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!