Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to create a linktable which connects 3 fact table and one Master calender. I dont want to concatenate two tables Quote and Opportunities though there are many common fields.It would be great if anyone could tell me how i can do this. Please find the data model below:
I would strip the common dimension fields out into a dimension table, and then link them to the fact tables (opportunity and quotes).
QlikView handles it better (and the model is simpler) if you were to concatenate the fact tables, otherwise you have to ensure they have sepearte keys etc, to avoid circular relationships. Confusion is avoided through clearly named fields.