Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to know about incremental load.
For an example:
1. I have made an "RA.qvw" with all my scripting in (getting data from my DB) - And Stored all my tables into QVDs
2. I have loaded QVD into an RB.qvw - with nothing done (QVD optimized load)
3. I have binary loaded RB.qvw into RC.qvw (loads really really fast) 1 sec or so for 25mil rows
My question is, how do i do incremental reload? and where do i do it?
I would say full load from RA.qvw and Incremental load from RB.qvw??
Please help!
Thanks in advanced
I know - but you still need some date in your dimension to check when the row is changed, otherwise you wont get it in your incremental load. Right?
Hi,
Yes you will need to store it as a field in your QVD.
Regards,
Kaushik Solanki