In which scenario Link table should not used be used?

[Tanish]

Hello,

Can anyone explain the scenario when we should not go with Link table. Some use cases where it is not used?

Is Link table and Fact constellation same. if both are different then what is the difference.

Thanks

[marcus_sommer]

I think it's very rarely that a link-table data-model is really necessary or may have any benefits against other data-models. Therefore it should be never used and you should always start with the officially recommended data-model which is a star-scheme.

- Marcus