where exactly in dataware house a confirmed dimension can
be created

Answer Posted / sandeep.pamarati

A confirmed Dimension, by definition, means a single
dimension table is actually connected to more than one fact
table in your dimensional model.
So, if a dimension table is shared across two fact tables,
for example, then that dimension is called as Conformed
Dimension.

PS: It is NOT Confirmed Dimension but it is Conformed Dimension.

Is This Answer Correct ?    15 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is real-time datawarehousing?

607


What is the very basic difference between data warehouse and operational databases?

457


What are the different problems that ?Data mining? can solve?

2355


What is difference between e-r modeling and dimensional modeling?

511


What is a fact, dimension, measure?

556






What are the different types of scd's used in data warehousing?

601


What is meant by metadata in context of a data warehouse?

491


Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?

488


Explain the difference between filter and conditin?

566


Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?

538


What are modeling tools available in the market?

558


Explain is olap databases are called decision support system true/false?

556


What are necessary tasks to install reportnet software?

515


If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

514


Which component has onread method and what it is used for?

509