My problem is i dont have fact table with keys pointing to other master dimension tables.So that I cannot able to design a Star schema to get better performance results.
My schema which i designed is a Snow Flake schema and there is no fact. I am looking for suggestions to build a star schema. Please find the attachment of my schema in which I mentioned actual keys pointing between tables.
Please suggest any technique on how to design a actual schema in qlikview
It best to put every field in the example you've gave so we can grasp and find a way to make a fact table out of your tables. There can be a fact table witch the only link is a common date. This will give you a possibility to create a Master Calendar so you can workout in your Data Model.
Just saw your full Data Model and I would consider leave the detail tables outside the fact table as they will be a dimension table, then concatenate all the other tables to create a Single Fact Table and if there is a common date to all tables besides the details tables rename it to a simple date. I strongly suggest you to try this approach as I could see that you have more than one fact table.
sure I will try this approach but i have doubt. are you saying that detail tables means Master Tables to left behind. Just like BedMaster,Department Master,Registration, Registration Details. And to concatenate Admission, Visit..etc