How to Select an ETL Tool For Datawarehousing

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

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Data Integration Concepts|1 Comment

Learning About Exchange Partition Mechanism – Oracle

If you have been involved in creating and managing ETL (Extract, Transformation and Load) processes for datawarehousing environments, you know how time consuming it can be especially when data volume is high. One of the best features in Oracle data warehousing is the ability to swap-out standard Oracle tables and partitioned tables. If you are [...]

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Oracle|6 Comments

Fundamentals Of Big Data And Hadoop Ecosystem

Big data, as the name suggests, is a collection of large datasets that any organization puts together to serve specific analytical goals and to support their operations. The concept of Big Data is often used to denote a storage system where different types of data in different formats can be stored for analysis and driving [...]

By |2016-10-31T14:21:28+00:00February 22nd, 2015|Big Data|0 Comments