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
How to join 3 database like flat file, oracle, db2 in informatrica?
What is data warehosuing hierarchy?
What should I have in mind when building olap solution from scratch?
Explain the difference between keylokup and joiner?
Database in use is oracle?
What is a Decision Tree Algorithm?
How to test report in reportnet?
What are data modeling and data mining?
What is execution plan?
Can you brief about the Data warehouse project you worked on?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Explain the difference between dw and bi?
Explain the difference between oltp and olap?
What is a data warehousing?
Compare aggregates and data marts