1.

What are the advantages and disadvantages of the top down approach of data warehouse architecture?

Answer»

Following are the advantages of the TOP down APPROACH :

  • Because data marts are formed from data warehouses, they have a consistent dimensional perspective.
  • This methodology is also thought to be the most effective for corporate reforms. As a result, large corporations CHOOSE to take this method.
  • It is simple to create a data MART from a data warehouse.

The disadvantage of the top down approach is that the COST, time, and effort required to design and maintain it are all very expensive.


Discussion

No Comment Found

Related InterviewSolutions