This is a large and complex topic. Are you thinking cloud or on-prem? I teach a course on modern cloud data warehouse platforms in which I cover the key issues, how to select one, and compare 8 platforms, including Oracle ADW and Teradata Vantage on 16 key points. This is…

This is a large and complex question and depends on the use case and scale. Each platform has its advantages and there are significant pros and cons for each platform. I am an independent consultant; I teach courses about these platforms and how to select one; and I advise…

In the answer below, I meant to add: there are some types of data where it does not add a lot of value to put the data in the data warehouse. An example would be a large audio or video file.   In this case, it makes sense to store the raw data objects in a data lake or…

Many of the comparisons of data lake and data warehouse that you see (such as the one below from Talend) are based on an out-of-date or dumbed-down idea of the data warehouse.   The more advanced data warehouse engines - support a wide range of data types and formats - can…

The answer is yes.    If this platform is supporting e-commerce, distribution or manufacturing then a critical component of the data warehouse may be the ability to support tactical or operational queries on data that is updated throughout the day. This considerably narrows…