Tag Archives: OMB

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 […]