Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48192 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / jaya
datamart is something which consists of only one type of
data whereas datwarehouse consists of data of different
type.For example all the organisation data say data related
to finance department,HR,Banking dept are stored in
datawarehouse whereas in datamart say only finance data
will stored.So datawarehouse is a collection of different
datamarts.
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
What are the various tools? Explain name a few?
What is the data type of the surrogate key?
What is incremintal loading?
Explain the definition of normalized and denormalized view?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
what are the all possible features supported modify stage?
Explain what is the metadata extension?
in general which algorithms for used?
Do you view contain data?
Explain what is data validation strategies for data mart validation after loading process?
Explain what is the difference between stop and abort?
What is hybrid slowly changing dimension?
What is the main difference between inmon and kimball philosophies of data warehousing?
What is the difference between filter and lookup transformation?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
