Two fact and multi dim

[Anonymous]

i have one scenario which is asked in interview.

"I have two fact table and multiple master(dimension) table from oracle and i want to create data model then how it will achieve "

how it will look??

[swuehl]

Have a look at

Concatenate vs Link Table