Basics - Do u need seperate space for Datawarehouse & Data mart

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Go To First | Previous Question | Next Question

Basics | Question 80 of 111

Do u need seperate space for Datawarehouse & Data mart

Total Answers and Comments: 3

Last Update: November 24, 2007 Asked by: chramgopal

Sponsored Links

Best Rated Answer

—

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

October 24, 2006 04:19:35

thumatinagaraju

Member Since: October 2006 Contribution: 26

RE: Do u need seperate space for Datawarehouse & Data ...

IN THE DATAWARE HOUSE ALL THE INFORMATION OF THE ENTERPRISE IS THERE BUT THE DATA MART IS SPECIFIC FOR THE PARTICULAR ANALYSIS LIKE SALES,PRODUCTION ....,,, SO DATA MART IS SUBJECT ORIENTED AND WAREHOUSE IS NOTHING BUT COLLECTION OF DATAMARTS SO WE ASSUME IT ALSO SUBJECT ORIENTED BCZ IT'S COLLECTION OF DATA MARTS ... SO FOR INDIVIDUAL ANALYSIS WE NEED DATAMARTS BYE FRIENDS YOUR'SNAG.

Is this answer useful? Yes | No

February 19, 2007 02:14:56

joesph

RE: Do u need seperate space for Datawarehouse & Data ...

hi friend the information you passed is correct. i differ from you a little

1) data marts is otherwise known as subset of data ware house

2) after creating a data marty marts and then creating DWH willl be better

Is this answer useful? Yes | No

November 23, 2007 06:13:31

Ram

RE: Do u need seperate space for Datawarehouse & Data ...

I think the comments made earlier are not specific.
We dont required any seperate space for data mart and data where house unless until those marts are too big or client required.
We can maintain both in a same schema.

Is this answer useful? Yes | No

Go To Top