how can one connect two fact tables ? is it possible ? how?

Answer Posted / dinesh

Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron

1947


Explain why fact table is in normal form?

538


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.

1818


How to improve session performance in aggregator transformation?

531


Explain what is ods (operation data source)?

547






Explain what are the tasks that loadmanger process will do?

483


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

556


Explain what are the mapping paramaters and maping variables?

561


What is a source qualifier?

534


What is cost benefit analysis (cba)?

587


What are data modeling and data mining?

657


Explain what is type 2 version dimension?

603


Why is dimensional normalization not required?

627


What is a cube in data warehousing concept?

662


Explain the difference between filter and conditin?

566