Answer Posted / 19-10-2011
THE DIMENSION IS USED BY TWO FACT TABLES IS CALLED AS
CONFORMED DIMENSION.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the fundamental elements of the data warehouse?
Explain can a dimension table contains numeric values?
What is metadata in context of a datawarehouse and how it is important?
What is the difference between power center and power mart?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to limit the max no of rows retrieved in the report?
What should I have in mind when building olap solution from scratch?
Explain what are fact, dimension, and measure?
what is user variable in affinium campaign? and some real time examples.
What are snapshots? What are materialized views & where do we use them?
Explain what are the modules in power mart?
Explain where do we use semi and non additive facts?
What is dimensional modelling?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
In a star schema, are foreign key constraints between facts and dimensions neccessary?