Satellite Load Code example in Oracle Warehouse Builder (OMB) script.
Tag Archives: ETL
OWB/OMB Script Annoyances – More!
Short excerpt on existing issues I’m finding, and incosistencies in the OMB/OWB product.
OWB / OMB Code Generated for Link Tables
OMB/OWB Data Vault Link Code generated from a couple simple inputs.
OWB vs Informatica – Design Time Comparison
A brief description comparing design time effort in OWB (oracle warehouse builder) and Informatica PowerCenter.
Services To Generate ETL Load Code
How would you like to take: a) a source model, b) target model, c) cross-reference (source-to-target) spread-sheet, push it IN to a service, and automatically generate Target ETL Loading Code? I’ve got a service I’m working on that does just that. I hope it’s available soon. For now, here’s some preliminary information & an example […]
OWB 11gR2 & Scripting Quirks
In case you’re following me for this, you’ve noticed that what I must be doing is generating ETL code… Well, you’re absolutely correct. I’m using patterns in the Data Vault, patterns in source system models, and patterns in code generation to generate ETL code for OWB. In this case, it’s OMB Script (TCL script) that […]
Overview of Data Vault Loading Patterns
This is a blurb about loading processes, and the patterns that exist in the Data Vault. It introduces the concepts of code-generation.
Oracle Warehouse Builder – OMB Script quirks
This is a look into tidbits of implementation for structures in OMB/OWB code.
Dynamic Data Modeling, Auto-Adaptation
I’ve long held a belief that the Data Vault modeling style ushered in a new era, that being one where we have the power to dynamically accept and automatically absorb new data elements. Of course, as always there are some rules and regulations (patterns) around when and how this can happen, and when the modeling […]
ETL and the Data Vault
First posting about implementation, design paradigms, the value of patterns in the Data Vault modeling and methodology.