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 term Data Independence?
Write out the disadvantages of using the Alias?
When the collision and overlapping take place at same time, what will be the bucket size?
Briefly explain the capabilities and concepts of Business Object?
Elucidate how many kinds of dimensions are accessible in the Informatica?
States the term Volatile temporary tables.
In which case the functional dependencies are not equations? Describe briefly?
What is meant by the snow flake schema?
Elucidate how many ways you make ports?
Specify the difference between the ER Modeling and Dimensional Modeling?
18,76,764
1954370 Asked
3,689
Active Tutors
1443731
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!