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
- 7195 Views
- IBM, MAHINDRA, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / abhi thakur
A confirmed Dimension table is joined with more than one
fact table in dataware house as same name.
The date dimension is created by a stored procedure. we
insert data into a table at an atomic level.To insert date
value into a date column the valid state is DD-MM-YY.
For different contries say YYMMDD for italy and MM-DD-YYYY
for france.These are only representation of date format.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what type of raid setup would you put your tx logs?
Explain can report net connect multiple datasource at a time in report creation time?
What is the difference between star and snowflake schemas?
Explain what is data validation strategies for data mart validation after loading process?
What are the differences between datamart vs. Reporting cube?
How do you define data block size?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
Explain is olap databases are called decision support system true/false?
What are aggregate transformation?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
Explain the difference between keylokup and joiner?
Explain what does level of granularity of a fact table signify?
Explain what are the advantages of query studio compared to report studio?
What is perform recovery?
Explain what are data marts?
