Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48815 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / abhinav
data warehouse
1. DW is a collection of information for all enterprise wide.
2. it usually contain the historical data.
3.information for analysis diff. department.but can manipulate/alter the data after authorization permission.
4.store the data for corporate view.
data mart
1. it is a part of the DW.
2. its gives the total information of the particular department.
3. it allow the user to update the data for transactional use.
4. it's mostly used by the department view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are partition points?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Which are the olap tools available that are supported by oracle?
Explain differences between star and snowflake schemas?
What is the difference between filter and lookup transformation?
What are the steps involved in creating dimensional modeling process?
What are the steps of implementing data warehousing?
What is the 4 + 1 view model as it relates to system modeling?
Explain what is real time data-warehousing?
Name a few sectors which use data warehousing?
What is difference macros and prompts?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
What is crass reference table?
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
