What is the difference between a data warehouse and a data mart?
Answer Posted / naveen goyal
In Data warehouse, staging area is used for mapping and
integration of data collected from different sources, but in
data marts staging area is eliminated because data directly
transfers from various source systems to data marts.
| Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
How to add a number to a macro variable?
Whether dimension table can have numeric value?
What is a source qualifier?
What is the use of tabular model, tabular sql, tabular reference in real time application?
what are the other factors of the database on which the loading performance depend?
Which technology should be used for interactive data querying across multiple dimensions for a decision making for a dw?
explain about balanced dimension,
What is the difference between datawarehouse and bi?
What does level of granularity of a fact table signify?
Explain what is the extension of file to save template?
how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause
What is a full backup?
How to create context?
Difference between cold fusion 5 and cold fusion mx 6?