incremental load

[NavinReddy]

Hi All,

Incremental load where can we get Updated records

it mean which line of code

Thanks in Advance

Niranjan

[kaushiknsolanki]

Hi,

     Do you mean, How to implement the Incremental load?

     or you want to know what does incremental load means ?

Regards,

Kaushik Solanki

[sasikanth]

hi niranjan ,

--------------------------------------------------------------------------------

EMP_Load:

select * from MSBI.DBO.Employee

where HireDate>$(MaxDate1);

load * from D:\EMP_inc.QVD(qvd)

where not Exists(employee_id);

inner join (EMP_Load)

select * from MSBI.DBO.Employee;

------------------------------------------------------------------------------------

Here we will get newly  or updated records ...

[NavinReddy]

No, while using incremental load how can we get incremental load,

i.e, where modification time>reloadtime();  wherenot exits.

what should i suppose to say if some one ask

plz help me

thanks,

Niranjan

[kaushiknsolanki]

Hi,

     Do you mean that you want to have the understanding of the script how it works?

     Then this is the best example, have a look at the attached presentation and also below vid.

     http://www.learnqlickview.com/incremental-data-load-in-qlikview/

Regards,

Kaushik Solanki

[sasikanth]

i didnt get u niranjan can u please explain me more ...

[NavinReddy]

yes i got it,for your reply

Thanks for your giving valuable information

R egards

Niranjan