Design - Tables with multiple links and loops

Mon, 22 Feb 2016 19:54:59 GMT

Hello All,

I'm facing a problem with the design of my model in qlik sense : I have in my datawarehosue several (dimension) tables that have multple links withe other tables. For example :

Here the problem is that

- A contact is linked to 1 company and 0 or 1 organisation --> I cannot break the link between company and contact

- An organisation is linked to 1 company

This is very simplified, but the 3 tables also have multiple links to my fact table (purchase).

So I have a loop. My first idea was to load my Organisation table twice with 2 different names. But this happends on a lot of other tables in the dwh, so I want to make sure I'm doing the right thing here.

Would there be any other solution than loading the tables multiple time? Do you guys think I have a design issue in my datawarehouse?

I'm a bit lost here, so I'd really appreciate any comment/help.

Thanks a lot,

Olivier.

Re: Design - Tables with multiple links and loops

swuehl — Mon, 22 Feb 2016 20:50:39 GMT

I think you need to clarify the semantics of the entitities in your model, there can be good reasons to load a master table multiple times:

Why You sometimes should Load a Master Table several times

Circular References

topic Design - Tables with multiple links and loops in App Development

Design - Tables with multiple links and loops

Re: Design - Tables with multiple links and loops