I have built a QlikView script generator (QVS), that can be used to generate large script files for data imports from SQL Server to QlikView.QlikView does not like 'fully' normalised database structures (loops between several tables): for example, three tables A, B, C in SQL Server could have three PK/FK links; in QlikView it requires just two. So, I now have to 'denormalize', or remove the loops between tables...Currently I am creating an 'exclusion table', which I traverse with an quad-imbedded for-loop, to isolate and remove constraints in the DB structure before generating the script file. This seems to work, but takes WAY too long as the number of tables can be large.Is there another way that I can achieve what I want more economically?
Algorithm to denormalize database
c#;sql;sql server;business intelligence