What are the advantages and disadvantages of the bottom up approach of

1.	What are the advantages and disadvantages of the bottom up approach of data warehouse architecture?
Answer» Following are the advantages of the bottom up approach : The reports are GENERATED quickly since the data marts are CREATED first. We can fit a GREATER number of data marts here, allowing us to expand our data warehouse. In addition, the cost and effort required to build this MODEL are quite minimal. Because the dimensional view of data marts is not consistent as it is in the top-down approach, this model is not as strong as the top-down approach and this is a DISADVANTAGE of the bottom up approach.

What are the advantages and disadvantages of the bottom up approach of data warehouse architecture?

Answer»

Following are the advantages of the bottom up approach :

The reports are GENERATED quickly since the data marts are CREATED first.
We can fit a GREATER number of data marts here, allowing us to expand our data warehouse.
In addition, the cost and effort required to build this MODEL are quite minimal.

Because the dimensional view of data marts is not consistent as it is in the top-down approach, this model is not as strong as the top-down approach and this is a DISADVANTAGE of the bottom up approach.

Discussion

No Comment Found

Related InterviewSolutions

What are the advantages of a cloud based data warehouse?
Differentiate between Agglomerative hierarchical clustering and Divisive clustering.
Differentiate between star schema and snowflake schema in the context of data warehousing.
What do you understand by data lake in the context of data warehousing? Differentiate between data lake and data warehouse.
What do you mean by dimensional modelling in the context of data warehousing?
What do you mean by data purging in the context of data warehousing?
Differentiate between a data warehouse and a data mart.
What are the advantages and disadvantages of the bottom up approach of data warehouse architecture?
What are the advantages and disadvantages of the top down approach of data warehouse architecture?
Explain the architecture of a data warehouse.

What are the advantages and disadvantages of the bottom up approach of data warehouse architecture?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment