Data Warehousing - What is the difference between dependent data warehouse and independent data warehouse?

GeekInterview.com > Interview Questions > Data Warehousing

Go To First | Previous Question | Next Question

Data Warehousing | Question 56 of 92

What is the difference between dependent data warehouse and independent data warehouse?

Total Answers and Comments: 3

Last Update: November 13, 2007 Asked by: Sunitha

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 30, 2007 15:32:31

sujithonrao

Member Since: July 2006 Contribution: 3

RE: What is the difference between dependent data ware...

I have never heard about dependent and independent dataware house. But there are dependent and independent data marts.

Dependent datamarts are those which depend on a dataware to for their data.

Independent datamarts are those which get their data directly from the operational data sources in the organisation.

Is this answer useful? Yes | No

November 12, 2007 05:29:53

ravi_kumar_garre

Member Since: November 2007 Contribution: 33

RE: What is the difference between dependent data ware...

There is a third type of Datamart called Hybrid. The Hybrid datamart having source data from Operational systems or external files and central Datawarehouse as well.
I will definitely check for Dependent and Independent Datawarehouses and update.

Regards,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

Is this answer useful? Yes | No

November 13, 2007 08:06:44

ravi_kumar_garre

Member Since: November 2007 Contribution: 33

RE: What is the difference between dependent data ware...

Hi I believe that Dependent Dataware house are build on ODS. And Independent Dataware houses are real-time dataware having no dependency on any ODS systems.

Regards,
Ravi Kumar Garre
ravi_kumar_garre@yahoo.co.in

Is this answer useful? Yes | No

Go To Top