How to optimize exporting data from database(Teradata)to qlikview
i have a large database which having 20 crores records for every sales org, So i have 3500 sales org ID like this and i'm fetching data for each sales org wise and making Qvd's so for every Qvd for a sales org its taking 6-8 hours , So overall its taking 18 days to reload the full Application and sometimes Reload task has been failing because of more time taking and have to reload that again.
What should i do in that case? how can i optimize it?
Re: How to optimize exporting data from database(Teradata)to qlikview
Thanks for the reply, i just have one doubt if direct discovery will fetch data directly from data source then application performance will go down as user selection response will go to data source everytime.