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
What is cubes?
Explain what is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain grouped cross tab?
Explain what is power center repository?
Can any one explain the hierarchies level data warehousing.
Explain what are the methodologies of data warehousing?
How to load the time dimension?
What is the difference between a primary and secondary actor in use case modeling?
What are the different methods of loading dimension tables?
What are the steps of implementing data warehousing?
What are steps we have to follow in designing the userfriendly universe?
Explain what is the extension of file to save template?
How to add a number to a macro variable?
After the complete generation of a report who will test the report and who will analyze it?