thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 24th, 2006

 

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.

joesph

• Feb 19th, 2007

 

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

Ram

• Nov 23rd, 2007

 

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.

Gvkishore

• Jan 16th, 2012

 

Why so.....Is there any advantage creating the DWH after creating the Datamarts...?

what is the use of Vice versa...?

moluguri

 Profile Answers by moluguri 

• Aug 30th, 2012

 

I think, we don't need separate space for Data Warehouse and Data Mart. Data Warehouse is a collection of Data Marts. Data Mart is a particular line of business..