I have a confusion regarding the use of Link Table and Concatenate of tables. Both used to avoid circular loop, synthetic tables etc. Recently I came to know from some developers that Link Table is a bad choice in data model, rather we need to use Concatenate. So can anyone tell me some situation where Link Table is the only solution and not Concatenate. I'll eagerly waiting to hear from you all.
If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post) and Helpful Answers (found under the Actions menu under every post).
If not, please make clear what part of this topic you still need help with .