What is DATA integration

Questions by msmart

Showing Answers 1 - 12 of 12 Answers

Sirini

  • Jun 14th, 2009
 

Data Integration is a process in which data from disparate, homogeneous or heterogeneous systems is cleansed, aggregated, consolidated, de-normalized and loaded into a single database or data warehouse after applying business rules.

  Was this answer useful?  Yes

tisha24

  • Oct 22nd, 2009
 

Data from different sources (like flatfiles, CSV, oracle, db2,teradata, mainfraes etc.) are extracted and transformed in to a single specific pattern (unique structure) and is know as integration of data.

The ETL tools like datastage, informatica and pentaho (open source) are used to convert the data from different format to unique format.  

Data integration involves data combining in different residing in different sources and providing users with a unified view of these data.This process becomes significant in a variety of situations both commercial and scientific (combining research results from different bioinformatics repositories, for example). Data integration appears with increasing frequency as the volume and the need to share existing data explodes.It has become the focus of extensive theoretical work, and numerous open problems remain unsolved.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions