Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8791 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 are the different problems that ?Data mining? can solve?
Why null values are mapped as 0 in fact tables?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
What are the types of dimensional modeling?
Store (and count) non-fact records?
Can you state some of the innovations throughout history?
How many types of facts and what are they?
What is batch processing?
What is the difference between dependent data warehouse and independent data warehouse?
Explain ddl (data definition language)?
Explain is olap databases are called decision support system true/false?
What is the metadata extension?
I have two universes created by two difference database can we join them in designer & report level? How
Explain multivalued dependency?
What is vdl (view definition language) explain?
