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
- 7199 Views
- IBM, MAHINDRA, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jay
Conformed dimensions mean the exact same thing with every
possible fact table to which they are joined.
Dimension tables are not conformed if the attributes are
labeled differently or contain different values.
Date Dimension is a confirmed dimension though thay have
different formats (Please correct me if I am wrong)
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sivakrishna
confomed dimension means the dimension is connected with
more fact tables is called .........
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / mithilesh kumar rai
If a Dimension is shared by all the star schema within the
DWH area, called Confirmed Dimension..
Ex: Suppose Comp_EMP_Master_dim is shared by all the Star
Schema/Fact Table.
here Comp_EMP_Master_dim will called Dimension Table
If a Dimension is shared by some the Star Schema in the DWH,
that is called shared Dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is the difference between metadata and data dictionary?
Fact table is in normalized or de-normalized form?
What is a Data Warehouse?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain what are the various transformation available?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
Explain dimension table ?
How can you set the session management?
What is the difference between dependent data warehouse and independent data warehouse?
Explain difference between view and materialized view?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Explain where do we use semi and non additive facts?
Teradata 
