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
- 9097 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
In document how to create metrics?
What are the difference between snow flake and star schema?
What we will do with the universe for faster process?
Explain the definition of normalized and denormalized view and what are the differences between them?
How to create context?
What is meant by metadata in context of a data warehouse?
How can we do data cleaning?
What is drilling across?
what are the all possible features supported modify stage?
Explain hybrid slowly changing dimension?
What is the function of surrogate key in data warehousing?
Ist the schema that a data warehouse system can implements.
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.
What are the different types of data warehousing?
Explain what is the extension of file to save template?
