As a sometime ETL coder I love the Oracle Merge statement. The ability to both insert and update in a single DML statement is great, and also gets around that age-old development question of which goes first the “insert” or the “update”? 481 more words
Tags » Data Warehouse
BI Apps data warehouse design is based on an assumption that the data warehouse schema design is independent from OLTP system.
The staging schema is an universal staging and the data warehouse is an universal data warehouse. 218 more words
I recently listened to a pitch by a vendor that was well spun. Let’s use this post to consider some spin around what is not metadata and what is a proprietary interface. 361 more words
Just a note on Data before we get started, i loved this quote which i recently got to read –
“Data are not taken for museum purpose; they are taken as a basis for doing something. 628 more words