topic Re: How to optimize exporting data from database(Teradata)to qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827953#M291487 <HTML><HEAD></HEAD><BODY><P>Hi Yogita,</P><P></P><P>please refer this thread</P><P><A href="https://community.qlik.com/thread/158294">How to optimize exporting data from database(Teradata)to qlikview</A></P></BODY></HTML> Tue, 31 Mar 2015 10:30:01 GMT avinashelite 2015-03-31T10:30:01Z How to optimize exporting data from database(Teradata)to qlikview https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827950#M291484 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i have a large database&nbsp; 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&nbsp; so for every Qvd&nbsp; 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&nbsp; and have to reload that again?</P><P></P><P>What should i do in that case? /how can i</P></BODY></HTML> Tue, 31 Mar 2015 10:16:44 GMT https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827950#M291484 2015-03-31T10:16:44Z Re: How to optimize exporting data from database(Teradata)to qlikview https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827951#M291485 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 31 Mar 2015 10:25:37 GMT https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827951#M291485 rubenmarin 2015-03-31T10:25:37Z Re: How to optimize exporting data from database(Teradata)to qlikview https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827952#M291486 <HTML><HEAD></HEAD><BODY><P>No i can not use incremental load , because of Slow changing dimensions , So i don't have that option ..</P></BODY></HTML> Tue, 31 Mar 2015 10:28:20 GMT https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827952#M291486 2015-03-31T10:28:20Z Re: How to optimize exporting data from database(Teradata)to qlikview https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827953#M291487 <HTML><HEAD></HEAD><BODY><P>Hi Yogita,</P><P></P><P>please refer this thread</P><P><A href="https://community.qlik.com/thread/158294">How to optimize exporting data from database(Teradata)to qlikview</A></P></BODY></HTML> Tue, 31 Mar 2015 10:30:01 GMT https://community.qlik.com/t5/QlikView/How-to-optimize-exporting-data-from-database-Teradata-to/m-p/827953#M291487 avinashelite 2015-03-31T10:30:01Z