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.
Why we use Context? And explain the LOV?
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
What are the types of prompt?
Describe how operation is carried out within the spiral method?
Explain terms Procedure Cache in Sybase. Answer: It is the memory area where compiled query tree run for example: procedure and batch query.
Illustrates the term data sparsity and how this effect upon aggregation?
Describe the term Java bean?
Specify the types of the tracing level?
Describe briefly the different methods of loading Dimension tables?
What do you understand by the term cascading update in DBMS?
18,76,764
1924170 Asked
3,689
Active Tutors
1443370
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!