Discussion Board for collaboration on QlikView Scripting.
I have to extract One Fact Table from Database to QVD.
Fact Table having more than 200 Crores(2 billion rows) Rows Data.
to reduce extraction time i have splitted based on Year wise.
I am using individual QVD generators for Year wise QVDs. Even its taking morethan 3 hours time to complete reload.
any one suggest how to reduce reload time?
Note: Full Load only..Not possible to Implement Incremental Load
What is "Crores" ?
You might have a look at this post: How qlikview can handle a billions of records?
I guess that 200 Crores is 2 billion rows right?
3 hours is not really a whole lot of time for 2 billion rows - but that depends a lot on your hardware and infrastructure.