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 / 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 is Discover and Execute in XMLA?
what is difference between drill & scope of analysis?
How to pivot data using informatica when you have variable amount of pivot rows?
How to know the time taken for particular report execution?
What are aggregate transformation?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What are algorithms provided by Microsoft in SQL Server?
What are the other names given to data warehousing?
Give some difference between oltp and olap.
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
Suggest a good author for hyperion in data warehousing?
Explain difference between data ware house & data mart?
Explain what are the possible data marts in retail sales?
What is Sequence clustering algorithm?