I am using various volatile teradata tables in my qlikview application. After creating all the volatile tables I am selecting all the fields with select statement . There are 54,259,926 lines fetched .In teradata the records are fetched with in ten to fifteen minutes .But in qlikview it takes more than four hours. What needs to be done to reduce the duration . The records keeps increasing since the data keeping adding in all the teradata tables everymonth .
Can anyone please guide me on how to resolve the duration problem of fetching of records in qlikview
Incremental load will help you to reduce reload time . There is no need to do full reload every day . You can just fetch newly created , updated , deleted records from Teradata.
Incremental load will reduce total reload time by 70-80% .
I am not doing reload everyday . Only once a month . Fourth of every month report gets reloaded. How this needs to be incorporated in qlikview if I am trying to use incremental load.