Data Integration Concepts

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

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

Convert Legacy System Data Into Oracle ERP System

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

When a new ERP implementation is planned, it is usually a well planned, multistage process. Based on my experience of converting legacy data into Oracle E-Business Suite, I am going to share a few things about this process. By the way, I have spent about 7 years of my life converting legacy data into Oracle [...]

How to Select an ETL Tool For Datawarehousing

By | February 22nd, 2015|Data Integration Concepts|

Selection of an appropriate ETL tool is the most important decision that has to be made in choosing components of a data warehousing application. The ETL tool operates at the heart of the data warehouse, extracting data from multiple data sources, transforming the data to make it accessible to business analysts, and loading multiple target [...]