Data Marts

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

How Master Data Management And Big Data Relate

By | March 30th, 2015|Big Data|

Master data is basically a shared master copy of data such as customer, product, employee, suppliers and location data used by several applications within an enterprise. Master Data Management (MDM) is important to organizations today because it allows an enterprise to have a single version of the truth. Without a clearly defined master data, any [...]

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