How to design the structured data model(Star Schema and Snow flake) when there is no data model in place already!
Hi All,
We are very new in to qlikview technology and we don't have any structured data model in place for any of the existing application. We are planning to build BI for few of the projects. Because of this we are struggling to get adjusted with qlikview technology like data model design(Star Schema and Snow Flake design) and also avoiding the synthetic key and loosely coupled tables.
We currently wrote queries to pull the required data from the database and joined the table according to the relation with keeping any model in mind. I have attached the document for you to work with. . Attached file contains 2 document! c2sfa_latest_new_Scrambled.qvw document contains all the table without any join query written to simply the structure. But this has so many issue such as synthetic key issue and loosely coupled table. So as to avoid these kinds of issue I created one more document called c2sfa_latest_new_1_Scrambled.qvw in that I have joined 4 tables in to one using left join. Though I managed to avoid the synthetic key issue and loosely coupled table I am not still getting the memory related error message. Also though I have simplified the data model I am not able to do the incremental load as it is very much necessary for my application the reason for this that I have joined several tables into 1 using the left join. So I that case I think incremental load may not be possible. Please correct me If I am wrong here. My doubt for this document is that why there is a memory issue though there is no synthetic key or loosely coupled table.
Choose the best of this two document and requesting you to work on it. But please keep in mind that I want to incremental for whatever the data model you are designing.
Note: c2sfa_latest_new_1_Scrambled.qvw doesn't contain all the tables.
-----------
Can some one please suggest me what can be done at this stage. Hope some one who has undergone the same position like us can help us. We don't know what has to be done for the above said problems.
Also let me know how can start designing the data model when there is no structured data model in place.
Hope some experts who are in qlik community can help me out!
