What is the difference between a data warehouse and a data mart?
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
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain what are the advantages of query studio compared to report studio?
What are the other names given to data warehousing?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what are non-additive facts in detail?
Explain what are the steps to build the data warehouse?
What is the difference between connected and unconnected stored procedures?
Code the tables statement to produce a multi-level frequency?
What are non-additive facts in detail?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is ods (operation data source)?
How to get the first 100 rows from the flat file into the target?
Explain grouped cross tab?
What is a core dimension?
what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc