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
- 7580 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
Explain where do we use semi and non additive facts?
Explain a linked cube?
What is hybrid slowly changing dimension?
What are data modeling and data mining? Where it will be used?
Can we take backup when the database is opened?
What is a real-time data warehouse?
Explain what is the difference between power center & power mart?
What is called dimensional modelling?
Explain what is metadata reporter?
What is the very basic difference between data warehouse and operational databases?
Code the tables statement for a single-level (most common) frequency?
Explain the definition of normalized and denormalized view?
What are the types of dimensional modeling?
if you use oracle sql*loader , how do you transform data with it during loading?
what are the other factors of the database on which the loading performance depend?
