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.
- 4 Answers
- 7191 Views
- IBM, MAHINDRA, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / jay
Conformed dimensions mean the exact same thing with every
possible fact table to which they are joined.
Dimension tables are not conformed if the attributes are
labeled differently or contain different values.
Date Dimension is a confirmed dimension though thay have
different formats (Please correct me if I am wrong)
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are the steps involved in designing a fact table?
What is scd1 , scd2 , scd3?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are partition points?
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?
Give some difference between oltp and olap.
What is data type of the surrogate key?
What are the approaches used by optimizer during execution plan?
How do we design a universe?
What is vdl (view definition language) explain?
Explain about core dimension,
What are the various methods of getting incremental records or delta records from the source systems?
How to design file watch jobs?
What is a fact, dimension, measure?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
