ETL Performance

How To Load Star Schema Dimensions And Facts In Parallel

By | December 19th, 2015|Data Integration Concepts|

One of the bottlenecks often encountered in ETL development for start schema is the sequence of loading dimension tables before being able to load any fact table. Obviously, it happens since fact tables need those surrogate keys from dimension tables in any dimensional data model. I always wondered if there could be a better way [...]

Using Oracle’s Partition Exchange Load for Very Large Target Tables

By | September 15th, 2015|Oracle|

The situation is very common in Data Integration where a good performing ETL load starts to slow down. The job that been running and loading data just fine, suddenly becomes too slow and becomes a bottleneck. There are many technical explanations for this to happen. Just to name a few, stale statistics, outdated hardware, software, [...]