tag:blogger.com,1999:blog-11909584.post3303909971932692700..comments2024-03-26T03:58:05.993-07:00Comments on Siddharth Mehta's Blog: SQLBI Methodology - ReviewSiddharth Mehtahttp://www.blogger.com/profile/02870225483799389119noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-11909584.post-89218840725651219132011-01-06T09:19:40.584-08:002011-01-06T09:19:40.584-08:00Thank you for reading and commenting the paper, fe...Thank you for reading and commenting the paper, feedback is welcome!<br />Just a few notes:<br />- The OLTP Mirror is a logical layer that we usually implement in a physical way by creating snapshot for entities (customer, product, ...) and by using views for transactions (that are not supposed to change over time)<br />- The DWH has an Inmon design (it uses business key) and the DM has a Kimball Design (star schema and surrogate keys). This is a very important part and it is fundamental to solve many issues of maintenance over time, when different requests needs to be implemented on the DM sideMarco Russohttps://www.blogger.com/profile/03947004727803583866noreply@blogger.comtag:blogger.com,1999:blog-11909584.post-70454245902519970882011-01-06T02:48:23.516-08:002011-01-06T02:48:23.516-08:00Congratulations!!! Siddarth for Your MVP Title. Ve...Congratulations!!! Siddarth for Your MVP Title. Very well deserverd one!!Jalpesh Vadgamahttps://www.blogger.com/profile/11897824025804539164noreply@blogger.com