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
- 8935 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
How can you set the client management?
Explain is fact table?
What is vdl (view definition language) explain?
What are the design methods of data warehousing?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What is drill-through?
Is there any difference in testing database and data ware housing?
What are Non-additive facts?
What are the key features of chameleon that separates it from other algorithms?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What is called data cleaning?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain normalization?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Where the cache files stored?
