I am new to data modeling of Qlikview. Recently I have loaded two transaction tables and four master tables and while looking at the association in table viewer, I found one additional table having all common fields available in master and transaction tables with a additional key. After that I read about this and understand the concept of Synthetic key and table.
There is disconnect between different professionals regarding Synthetic keys are good or bad. What I believe that if your document has multiple synthetic keys that shows there is some serious issues with data model.
Here can you help me to guide best ways to remove synthetic keys or in other words how can I improve data model?