Basics - What is DATA integration

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 110 of 113

What is DATA integration

Total Answers and Comments: 3

Last Update: October 22, 2009 Asked by: msmart

Sponsored Links

Best Rated Answer

—

Submitted by: ksa_rama

A data integration system combines the data residing at
different sources(ex.oracle,db2,teradata) and provides a unified, reconciled view of the data for the ETL process

Above answer was rated as good by the following members:
sobhit17, mri_sonam

August 06, 2008 10:36:34

ksa_rama

Member Since: August 2008 Contribution: 2

RE: What is DATA integration

A data integration system combines the data residing at
different sources(ex.oracle db2 teradata) and provides a unified reconciled view of the data for the ETL process

Is this answer useful? Yes | No

2 0

Overall Rating: +2

June 14, 2009 02:06:00

Sirini

Member Since: June 2009 Contribution: 3

RE: What is DATA integration

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.

Is this answer useful? Yes | No

October 22, 2009 08:07:38

tisha24

Member Since: September 2008 Contribution: 10

RE: What is DATA integration

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank