where exactly in dataware house a confirmed dimension can
be created
Answer Posted / dipti a
Conformed Dimension is the dimension table which is shared between 2 or more fact table. From reusability perspective its very important. Such type of dimensions one can see it in Galaxy schema / fact constellation schema.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain what is the data type of the surrogate key?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
How to design file watch jobs?
What is a core dimension?
How can you communicate with web server (apache or iis) from coldfusion?
What is the difference between view materialized view and view?
Explain the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs.
What is incremintal loading?
Explain what is difference between query studio and report studio?
Explain the data type of the surrogate key?
Explain can report net connect multiple datasource at a time in report creation time?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
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?
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?