I am pulling the necessary tables from transaction database and keeping the same links as in source db while buiding data model in Qlikview. I am achiving this by using Qualify*; and Unqualifty <keyfield>; above each table in qlikview script, so that I can avoid synthetic keys and circular references. I am doing this so that I dont build wrong data model, as I still not fully aware of the business. Anyway later I will be changing the model(using calcuated fields, lookups, left joins, concatenation etc) based on the requirement.
1.Is this the right approach?
2.In a general scenario, how developers understand the exising transaction database. I mean, do I need to know each column in the table that I will be pulling in qlikview? I am getting lost somewhere while seeing multiple tables in source db, as there are many tables which has same field names, so understanding functionality is becoming tough. Please point me to the right apprach.
3.How to get a idea about when to go with left join? I know that 'left join keep all rows in left table and brings matching rows from right table based on key field'. I wanted to know some business scenario, when I can go with left join.
