Answer Posted / guest
1. Dimension
2. Detail
3. Measure
| Is This Answer Correct ? | 14 Yes | 72 No |
Post New Answer View All Answers
Explain me what are data marts?
Where the cache files stored?
Is there any difference in testing database and data ware housing?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain the differences between normalizer and normalizer transformation?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
What are the mapping paramaters and maping variables?
Explain degenerate dimension table?
What should I have in mind when building olap solution from scratch?
explain about dirty dimension?
What is surrogate key? Where we use it explain with example?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is vdl (view definition language) explain?
Explain what are fact, dimension, and measure?