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 are the differences between datamart vs. Reporting cube?
What is the difference between drill through and masterdetail reports?
What is crass reference table?
What are the different types of data warehousing?
What are the types of partitioning?
What is surrogate key? Where we use it?
In microstrategy, how can we direct the sql generated to use a specifc table?
Can you state some of the innovations throughout history?
How to stop a batch?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
Explain the definition of normalized and denormalized view and what are the differences between them?
What is data warehouse architecture?
What is dimensional modelling?
What is data stream and data adaopter. Is it same are different? Explain?
What is latest version of power center / power mart?