Incremental load

[#1]

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

[#2]

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?

[kaushiknsolanki]

Hi,

     Yes you will need to store it as a field in your QVD.

Regards,

Kaushik Solanki