International Journal of Advanced Research in IT and Engineering

  • Year: 2016
  • Volume: 5
  • Issue: 7

Extract transform load data with etl tools like ‘Informatica’

  • Author:
  • Preeti , Neetu Sharma
  • Total Page Count: 26
  • DOI:
  • Page Number: 17 to 42

*M. Tech., Computer Science Engineering, Ganga Institute of Technology and Management, Bahadurgarh-Jhajjar Road, Kablana, Distt. Jhajjar, Haryana

**HOD, C.S.E Deptt., Ganga Institute of Technology and Management, Bahadurgarh-Jhajjar Road, Kablana, Distt. Jhajjar, Haryana

Abstract

As we all know business intelligence (BI) is considered to have an extraordinary impact on businesses. Research activity has grown in the last years [10]. A significant part of BI systems is a well performing Implementation of the Extract, Transform, and Load (ETL) process. In typical BI projects, implementing the ETL process can be the task with the greatest effort. Here, set of generic Meta model constructs with a palette of regularly used ETL activities, is specialized, which are called templates.