That depends on your req.Lets say for eg you have stored the data in table1 from db and the same way you stored the data in table2 from other source.if After some calculations you have to make linkage between the Table1 and table2 then you no need to get the data from db again by connecting you can get directly from the all ready stored tables.(From Tresecco :QlikView has Tab1 already loaded in memory so you don't have to get it from your original source, you can fetch it from memory.)
In the real time scenarios we cant run the extractors any time as because of db update or FTP cases.(little complex)
I forgot the above command to write in edit script. Now it was showing 15 records. I checked in data model, here synthetic keys are created...why it was showing 15 records...
If you refer temp1 as a resident table, you may prefer to have some transformation or other opertaions on data of resident table, temp1. Hence you may need to have another load for that transformation step.
