Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48632 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
Whether dimension table can have numeric value?
Explain difference between e-r modeling and dimentional modeling?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain difference between view and materialized view?
Give some difference between oltp and olap.
Explain what is cost benefit analysis (cba)?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain what are the vaious etl tools in the market?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain me what are data marts?
How to drill through from a powerplay cube to reportnet?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
If two relational tables are connected to sq trans, what are the possible errors it will be thrown?
Start a batches with in a batch?
What is critical column?
