3 ms·
>> ODS has a schema applied to it to make the data fit into a relational database structure. Yes, I get that. I was probably oversimplifying. Practically spea
by slantyyz 11y ago
>> ODS has a schema applied to it to make the data fit into a relational database structure.
Yes, I get that. I was probably oversimplifying.
Practically speaking, the BI projects I've been on for small to medium enterprises (<150M in size, non-tech) still have predominantly relational data sources.
In many of those cases, a warehouse is an expensive effort in over-engineering, but a data-lake-like ODS (without transformations in the main data tables) with curated subject-area marts is a more sensible solution.
--edit, added "non-tech" to my qualifier