Badges
35 Points
3 Years
User Activity
Over 3 years ago
Replied to reviewer1389651 Is a data warehouse the best option to consolidate data into one location?
@reviewer1389651 I believe you have misunderstood the meaning of "non-volatile" in the definition of data warehouse. If the ODS of a top-down architecture is temporally modeled, then the data captured is dynamic as data changes in the source systems. Non-volatile means that…
Over 3 years ago
Answered a question: What are the key reasons for choosing Snowflake as a data lake over other data lake solutions?
Snowflake is a columnar stored database. It is not a “data lake.”
Over 3 years ago
Answered a question: Is a data warehouse the best option to consolidate data into one location?
Your question is one about architecture, but I see some answers about the technology.
Choosing technologies is just as critical, but to your question, @David Rossi has it right. It sounds like a straightforward DW requirement. With the multiple source systems and potential…
Answers
Over 3 years ago
Cloud Analytics
Over 3 years ago
Data Warehouse
About me
With experience in data architecture for OLTP applications, business intelligence/data warehousing, data governance and master data management for a broad spectrum of industries, I offer unique insight to sound data management and data architecture practices for any business.
* Leader and mentor of database and software engineers.
* Software and database architect of systems focusing on availability, cost of ownership, compatibility, scalability, performance, and security.
* Evangelist promoting the business value of temporal relational data modeling for both OLTP and data warehousing systems, best practices in data governance, master data management and the software development lifecycle.