Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

ssriramin19
New Contributor II

Fetching of records


Hello,

      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

7 Replies
MVP
MVP

Re: Fetching of records

is incremental load an option?

ssriramin19
New Contributor II

Re: Fetching of records

Will the incremental load resolve the problem . ?

But why in qlikview it takes more time to fetch the records. It is close to five hours

suniljain
Honored Contributor

Re: Fetching of records

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% .

Not applicable

Re: Fetching of records

1) Take only required Columns or fields from Database

2) Fetch data without using any filters or functions and create QVDs

3) Use Incremental Load feature

ssriramin19
New Contributor II

Re: Fetching of records

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.

anbu1984
Honored Contributor III

Re: Fetching of records

Re: Fetching of records

Hi,

Check this.

Regards

ASHFAQ