What is the difference between a data warehouse and a data mart?
Answer Posted / sree
data mart is a scaled version of datawarehouse which
addresses to only a particular subject
datawarehouse is a database which allows to view the data
in different dimensions or perspectives
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Difference between cold fusion mx 6 and cold fusion mx 7?
How to load the time dimension?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
Explain what are the modules in power mart?
What are aggregate transformation?
What are the steps involved in designing a fact table?
How can we run the graph? How can we schedule the graph in unix?
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.
ware house management system is used?
Code the tables statement for a single-level (most common) frequency?
What are fundamental stages of data warehousing?
What are Aggregate tables?
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 is pre-emptive and non-pre-emptive?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?