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

Answer Posted / raj

Fact Tables are connected by confirmed dimensions, Fact
tables cannot be connected directly, so means of dimension
we can connect

Is This Answer Correct ?    12 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference between keylokup and joiner?

501


Difference between cold fusion mx 6 and cold fusion mx 7?

466


What are the methodologies of data warehousing?

568


Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?

491


How are the dimension tables designed?

558






Explain me what are data marts?

587


What is index awareness in universe?

570


What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

481


Can you state some of the innovations throughout history?

542


Explain what is cost benefit analysis (cba)?

535


Explain how are the dimension tables designed?

557


Explain what are components of reportnet?

546


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

541


Explain where do we use semi and non additive facts?

560


Explain what is ods (operation data source)?

542