A look at NoSQL, BigData, and Data Vault with regards to Transactions Per Second – the hype around ingestion rates, and questions around why / when you would or wouldn’t need to switch to NoSQL platforms to handle bigdata.
In this entry I will explore the use of implementation of Data Vault on Teradata. However, this entry is applicable to everyone in the Data Vault community, as it covers definitions and descriptions of primary keys, indexing, surrogate keys, natural keys, and performance and tuning.
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 […]
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 […]
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…)
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 […]
This is a look into tidbits of implementation for structures in OMB/OWB code.
A brief look into handling XML/XSD staging data using Oracle XDB technology.