Facebook Twitter LinkedIn YouTube RSS
magnify
Home Posts tagged "OMB"
formats

OWB/OMB Script Annoyances – More!

Published on 2010/06/03 by in ETL /ELT

Short excerpt on existing issues I’m finding, and incosistencies in the OMB/OWB product.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

OWB / OMB Code Generated for Link Tables

Published on 2010/05/25 by in ETL /ELT

OMB/OWB Data Vault Link Code generated from a couple simple inputs.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

OWB vs Informatica – Design Time Comparison

Published on 2010/05/21 by in ETL /ELT

A brief description comparing design time effort in OWB (oracle warehouse builder) and Informatica PowerCenter.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
10 Comments  comments 
formats

Services To Generate ETL Load Code

Published on 2010/05/20 by in ETL /ELT

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

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
No Comments  comments 
formats

OWB 11gR2 & Scripting Quirks

Published on 2010/05/20 by in ETL /ELT

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

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
8 Comments  comments 
formats

Oracle Warehouse Builder Install & Setup 11gR2

Published on 2010/05/19 by in ETL /ELT

I recently setup OWB for 11g R2 right after installing Oracle 11g.  It’s fairly smooth to do, but there are some quirks along the way, enough to drive you batty.  So I thought I’d share a few hints and techniques here…

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
3 Comments  comments 
formats

Oracle Warehouse Builder – OMB Script quirks

Published on 2010/05/03 by in ETL /ELT

This is a look into tidbits of implementation for structures in OMB/OWB code.

 
 Share on Facebook Share on Twitter Share on Reddit Share on LinkedIn
2 Comments  comments