ETL Challenges

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, [...]

Data Integration Techniques And Their Challenges

By | February 27th, 2015|Data Integration Concepts|

Data Integration is the combination of technical and business processes used to combine data from disparate sources into meaningful and valuable information. The process of Data Integration is about taking data from many disparate sources (such as files, various databases, mainframes etc.,) and combining that data to provide a unified view of the data for [...]