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
How can we load the time dimension?
How to import vsam files from source to target. Do we need a special plugin?
How we are using this function?
Explain about core dimension, balanced dimension, and dirty dimension?
Briefly state different between data ware house & data mart?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are vaious etl tools in the market?
How to get the first 100 rows from the flat file into the target?
What are session timeout and application timeout? Where we have to do this process?
What is cubes?
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
Why is dimensional normalization not required?
What is the difference between view filter and report filter?