What is the difference between a data warehouse and a data mart?
Answer Posted / harshad
More Spcific
DW Will be your target for historical data and will be use
for Analysis.
Data Mart would be your Source for DW and will be subject
oriented.
| Is This Answer Correct ? | 22 Yes | 12 No |
Post New Answer View All Answers
What are modeling tools available in the market?
Where the applications and where
What is the difference between ods and oltp?
Explain the difference between data ware house & data mart?
What is batch processing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
What is the main difference between schema in rdbms and schemas in datawarehouse?
What is a data warehousing?
What is informatica architecture?
What are components of report studio?
What is the difference between metadata and data dictionary?
What is the difference between Datawarehouse and OLAP?
What function should we use to display the value entered or selected by a user in response to a prompt?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.