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
- 8924 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 loops in Datawarehousing?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is Cognos script editor?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What is load manager?
What is the metadata extension?
Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar
How to handle multi value dimensions?
What is a hash cluster?
Explain where do we use semi and non additive facts?
What are the main steps to build the data warehouse?
What is the difference between metadata and data dictionary?
Explain which columns go to the fact table and which columns go the dimension table?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
What is informatica architecture?
