What is the difference between a data warehouse and a data mart?
Answer Posted / neha
The collection of the datamarts is non as dataware house.
The section or part of the dataware house is called data
marts.These data marts may be independent or dependent or
both.
| Is This Answer Correct ? | 13 Yes | 15 No |
Post New Answer View All Answers
What is analytical or analytic mean?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?
What is freehand sql?
How can we determine what records to extract?
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 operational data store (ods)?
what are the others of "bad files" and "discard files" when using sql*loader?
What is factless fact tables?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
what is parallel query?
Can decision tree be implemented using SQL?
Explain what are non-additive facts in detail?
What is difference macros and prompts?
What is a core dimension?