How to optimize exporting data from database(Teradata)to qlikview

[#1]

Hi,

i have a large database  has 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

[rubenmarin]

Hi yogita, you can look in QlikView help or in community how to do an incremental load, so each time you're creating your qvds they only load updated or new data, not all data.

[#3]

No i can not use incremental load , because of Slow changing dimensions , So i don't have that option ..

[avinashelite]

Hi Yogita,

please refer this thread

How to optimize exporting data from database(Teradata)to qlikview