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.




Answers were Sorted based on User's Feedback



what are confirmed dimension? We alwys give date as a conformed dimension but if it has differen..

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

what are confirmed dimension? We alwys give date as a conformed dimension but if it has differen..

Answer / sivakrishna

confomed dimension means the dimension is connected with
more fact tables is called .........

Is This Answer Correct ?    1 Yes 0 No

what are confirmed dimension? We alwys give date as a conformed dimension but if it has differen..

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




what are confirmed dimension? We alwys give date as a conformed dimension but if it has differen..

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

Post New Answer



More Data Warehouse General Interview Questions

Can we have multiple application.cfm file in an application?

0 Answers  


How did you plan your Data ware house project?

0 Answers   TCS,


What is the function of etl when used in data warehousing?

0 Answers  


What are the advantages and disadvantages of reporting directly against the database?

0 Answers  


What is a look up function? What is default transformation for the look up function?

1 Answers  






Where the applications and where

0 Answers  


What needs to be done while starting the database?

0 Answers  


What are components of report studio?

0 Answers  


What is loop in data warehousing?

0 Answers  


Explain degenerate dimension table?

0 Answers  


WHAT IS FACT LESS FACT TABLE?

6 Answers   DBS, Polaris,


What is an er diagram?

0 Answers  






Categories