Issue in incremental load script

Anonymous — Tue, 20 Oct 2015 16:46:01 GMT

Hello experts,

I am getting below in my test environment and it is working in Dev.

Inserts:

LOAD *

FROM

$(Vqvxpath)dim_account_inserts.qvx(qvx);

date_dim_account:

LOAD Max(account_record_updated_datetime) as dim_account_Maxdate

Resident Inserts;

LET VDate_dim_account = Peek('dim_account_Maxdate',0,'date_dim_account');

DROP Table date_dim_account;

STORE Inserts into $(Vqvdpath)dim_account.QVD(qvd);

DROP Table Inserts;

Updates:

LOAD *

FROM

$(Vqvxpath)dim_account_updates.qvx(qvx)

Where (account_record_updated_datetime >'$(VDate_dim_account)') ;

Concatenate

LOAD *

FROM

$(Vqvdpath)dim_account.qvd(qvd)

Where not Exists(account_key);

STORE Updates into $(Vqvdpath)dim_account.QVD(qvd);

DROP Table Updates;

Can anybody help me this one.

Regards,

kumar

topic Issue in incremental load script in QlikView