Answer Posted / pavithra
a) Primary dimension table
b) Secondary dimension table
c) Degenerate dimension table
d) Conformed dimension table
e) Slowly changing dimension table
f) Rapidly changing slowly dimension table
g) Large dimension
h) Rapidly changing monster dimension
i) Junk dimension
j) Role playing dimension
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is surrogate key? Where we use it? Explain with examples.
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?
What is drill-through?
What are cluster analysis in data warehousing?
Explain what are the different types of data warehousing?
Explain what are fact, dimension, and measure?
How to performance tune reports?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
Explain a relation schema and a relation?
What is Star Schema?
What is aggregate fact table?
After the complete generation of a report who will test the report and who will analyze it?
Explain what is the data type of the surrogate key?
How to drill through from a powerplay cube to reportnet?
Explain the definition of normalized and denormalized view?
