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?
What is the difference between static cache and dynamic cache?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What should I have in mind when building olap solution from scratch?
What is a relationship?
Explain multivalued dependency?
Explain what are the different types of join operations?
What are various warehousing tools?
Can you state some of the innovations throughout history?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What are the steps of implementing data warehousing?
In microstrategy, how can we direct the sql generated to use a specifc table?
How to generate iqd file from framework manager?
ware house management system is used?
What is the extension of file to save template?