Answer Posted / pratap gangula
A confirmed dimension is a dimension which can be joined with more than one fact table and can be reused in other data marts as well.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How to add a number to a macro variable?
What is the difference between static cache and dynamic cache?
What is a full backup?
What is the difference between mapping parameter & mapping variable in data warehousing?
what are different storage options supported by oracle ?
Explain what are components of report studio?
what are relationships?
Explain the difference between keylokup and joiner?
How to create prompts in report net?
What is hybrid slowly changing dimension?
What are components of reportnet?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
Explain what are slowly changing dimensions?
What is surrogate key? Where we use it explain with example?