I have like 3 Fact tables (no join/concanate) and for each of them I have a "bla bla AS Source..", so I end up with Source A, Source B, Source C, but the content is the same and there is several choices that the user needs to choose from.
At the front-end I need to put them together so the user only have one listbox, "one set of content". I cannot see how the concat can help here.
What is the correct solution for this? and of course I am concerned that the datamodel still work.
Well I know very well how to concatenate, though my first thought is always too join to avoid double data and add new fields. Why you like concatenate so much?
I already have a reload time beyond 1 hour, so whether I join or concatenate, dont you think it will just make thinks worse?
I like concatenate so much only when the tables contain the same content. I don't like making a data model any more complicated then it needs to be. If I can have one fact table instead of three the same content that sounds like a good deal to me. You could well have perfectly fine reasons to not concatenate the fact tables. I just haven't seen or heard anything concrete to tell me you do.
