Discuss the limitations of the independent data mart architecture
What will be an ideal response?
There are several limitations to the independent data mart including:
1. A separate ETL process for each data mart.
2. Inconsistencies between data marts because they are developed with different technologies sometimes.
3. It is difficult to relate data across data marts.
4. Scaling costs are excessive. Every new application that creates a separate data mart repeats the ETL process.
5. It is very expensive to make the data marts consistent.
You might also like to view...
Listing them in the proper order, what are the stages in the buyer decision-making process? Describe each
What will be an ideal response?
Agile Project Management is well-suited for instances where
A) Customer needs are well-defined. B) Time constraints exist. C) Customer needs change quickly. D) Budget constraints exist.