Huge data issue in Qlikview?????

[balasundaram]

Hi All,

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

Regards,

Bala

[petter]

What is "Crores" ?

[petter]

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.