This posting describes operational Data Vault nature, the question is how does ODV support CRUD?
Archive | ETL /ELT
RSS feed for this sectionContains postings about the trials, tribulations of technically implementing ETL for Staging Areas, Data Vaults, Data Marts, and basic technology issues.
Q&A:What does the ETL for DV look like? Sample?
This post discusses in brief, what the ETL implementation for a Data Vault might look like.
OMB/OWB Code for Loading Satellites
Satellite Load Code example in Oracle Warehouse Builder (OMB) script.
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 […]
Oracle Warehouse Builder Install & Setup 11gR2
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… (more…)
Oracle Configuration on Windows Vista…
What a pain. I’ve finally got my windows Vista box up and running with Oracle 11g – but it took quite a bit of fiddling with the settings. The install went great, then I tried to launch the configuration, that’s where things headed south… I learned about a couple tricks that I used to make […]