what are confirmed dimension?
We alwys give date as a conformed dimension but if it has
different format
for different contries say YYMMDD for italy and MM-DD-YYYY
for france.Then are they not confirmed.
Answer Posted / mithilesh kumar rai
If a Dimension is shared by all the star schema within the
DWH area, called Confirmed Dimension..
Ex: Suppose Comp_EMP_Master_dim is shared by all the Star
Schema/Fact Table.
here Comp_EMP_Master_dim will called Dimension Table
If a Dimension is shared by some the Star Schema in the DWH,
that is called shared Dimension.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Explain how many ways you create ports?
What function should we use to display the value entered or selected by a user in response to a prompt?
What are the methodologies of data warehousing?
What is cost benefit analysis (cba)?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what is metadata reporter?
What is your spectra photometer working principles?
What is the difference between power center & power mart?
What are session timeout and application timeout?
What are the advantages of query studio compared to report studio?
Explain what are the different types of data warehousing?
Describe a data warehouse.
What is difference between query studio and report studio?