Answer Posted / vasu bathula
DataMart is a subset of data warehouse and it is supports a
particular region, Business unit or business function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are components of reportnet?
What is data stream and data adaopter. Is it same are different? Explain?
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?
Suppose we want to display zero when null values coming to report how can we do that?
Explain me what are conformed dimensions?
Can you state some of the innovations throughout history?
Name a few sectors which use data warehousing?
What is surrogate key? Explain with examples.
What is your spectra photometer working principles?
What is the differences between star and snowflake schemas?
What are the types of partitioning?
What are the approaches used by optimizer during execution plan?
What is the difference between power center & power mart?
How to limit the max no of rows retrieved in the report?
Explain why are oltp database designs not generally a good idea for a data warehouse?