4 ms·

Hey, forgive my ignorance, I'm the guy who uses this stuff, not the guy who builds it. My understanding was that, typically, the DW is where the data gets ETLe

Hey, forgive my ignorance, I'm the guy who uses this stuff, not the guy who builds it. My understanding was that, typically, the DW is where the data gets ETLed from various places and lives in a normalized environment. Then from that big pool, departments get built columnar or OLAP databases for specific analyses they want to do, and I connect not to the DW but to the OLAP instance (we call it Datamart here). Was I living a lie? At first I thought that your master-segment system is the same, but then I read your comment. I looked into Greenplum a while back and wanted it because of Madlib, but my guys said "nope" and went with MS.

chris_wot 11y ago
It can be done with a dimensional scheme or with a normalised schema. Ralph Kimble argues for the dimensional approach whilst Bill Imon argues for the normalised approach. For myself, I tend to go with Kimble, but there are advantages and disadvantages to both approaches. Wikipedia has a decent summary of this here: https://en.m.wikipedia.org/wiki/Data_warehouse#Dimensional_vs._normalized_approach_for_storage_of_data https://en.m.wikipedia.org/wiki/Data_warehouse#Dimensional_v...